Contacts export display X400 not SMTP
I'm not sure if this behavior is by default or not, but when my users try to
export their contacts to an Excel file, any internal (domain) contacts show
the X400 address rather than the SMTP address.
Is there a way to change this? I've read some about VB scripts with CDO or
something, but hoping there is an alternate way.
what version Exchange?
Susan Conkey [MVP]
"Mike W." <wallmr_snowpam@gmailDOTC0M> wrote in message
> Hi all,
> I'm not sure if this behavio...please help #3
In Money 2003, when I receive payment on an invoice, it
automatically records it to my register. Is there any
way around this?
The reason is that I like to make one large deposit, and
I want this large deposit to show in my register, not the
...Timestamp a sheet #3
That works good. Thanks alot
eluehmann's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1309
View this thread: http://www.excelforum.com/showthread.php?threadid=26418
Your welcome, thanks for the feedback
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
"elueh...merging 2 -3 different MS money files into one
over a period of testing and doing other things i have created multiple MS
Money files mostly with the same accounts and same transactions, the main
difference is the transactions that are available in those files, the oldest
file has the oldest transactions and newest one has all the new transactions
but both contain some common
so i want to merge all of them into one so that i can get all transactions
from the begining till now. what is the best method to do this.
There is no good method. The only method, and not a good one, is File|Export
of individual accounts to .QIF ...Export to XML exports single row only
What I did: On XML source panel of Excel 2007 added XML map, mapped to
columns using ranges (i. e. A1:A1825), selected “Export” from “Developer” tab
in the ribbon.
Result: Output XML file contains only one record (first row from the
I’ve done this numerous times in Excel 2003 with no problem. What happens??
...Try to open table get this error
The Microsoft Jet database engine cannot find the input table or query
<name>. Make sure it exists and that its name is spelled correctly. (Error
This is the full error I get when I try to open a table. I tried compace
repair and that did not work.
How are you trying to open the Table? By double-clicking on it? By a
query? Through Design Mode?
Have you tried copying the Table to another name and openning the new table?
PS. Hope you have a good backup of the database? If not make one. If you can
just highlight the database and do a contr...sql report 3 tables
I am trying to write a report which will contain 4 tables, I need to display
all 4 tables on one page. Unfortunatley because of the siz of the first 2
tables the 3rd table sits way down on the right hand side, how can i
manipulate were the tables sit on the preview window?
Are you writing your report in visual studio?
in Report layout view, right click outside of the report area and select
Properties. from the second tab you can change the layout of the report. By
default it is set to 8.5 X 11, try chaning it to 11 X 8.5.
Also, try changing the font size in your tab...Validation #3
I am trying to use this formula LEFT(C15,3)="WCA" to
validate an entry , but it is not working.
Did you type the "=" sign before the LEFT(...), e.g.
In article <firstname.lastname@example.org>,
"Juran" <email@example.com> wrote:
> I am trying to use this formula LEFT(C15,3)="WCA" to
> validate an entry , but it is not working.
> Any suggestion?
Yes, I forgot to include =.
>-----Original Message---...Exporting Sent Email Addresses from Entourage
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I'm trying to export email addresses from an employee's Entourage, but would like to include email addresses in his "Sent Items" folder. Is there a way to export these email addresses aside from exporting the "MBOX" file, which has all the email content as well?
Thanks in advance!
On 3/12/08 8:49 AM, in article firstname.lastname@example.orgR9absDaxw,
"Quinlisk@officeformac.com" <Quinlisk@officeformac.com> wrote:
> I'm trying to export email addresses from an emplo...how to extract data from csv file? (part 3)
thanks so much for your advice and help... i really appreciate it... i
have tried your method to change the separator as u said but in fact,
mine was already set to the us standard... i run the command again but
again the data is all in one column... i know i can record a macro to
do the stuff that i need but because i'm working as an analyst and i
have to extract data from any csv files as and when needed and they
might not have the same structure and it would be faster and more
efficient for me if i can run what i need from just one command... what
i tried in my command is to t...getting rid of #DIV/0! #3
I'm receiving the subject error in my cells when referencing a cell without
a number. I plan to put a number in those cells as they come to me but I
don't want to see that error. I would like the cell to be either blank or
The cell is G2 in which I'm receiving the error.
Its formula reads e10/f10 where f10 is blanked unless I input a number.
Is there a way to do this? Any help is appreciated.
"Peter McCaul" <email@example.com> wrote in message
news:%2301eR2reHHA.3...Problem with OWA #3
We have a problem with Outlook Web Access, when a user is login in Outlook
Web Access, the list of E-Mails appears, click on a E-Mail the message is
displaying, everthing okay.
Click on a other E-Mail an error 404 (Page or directory not found) is
What could it be???
The environment is:
Windows 2000 Active Directory Domain Server
Windows 2003, Exchange 2003 Backend Server
Windows 2003, Exchange 2003 Frontend Server, Outlook Web Access
Thanks for any help
Greetings J�rg Schori
That sounds like URLScan blocking certain messages. See
http://support.microsoft.com/...Export / Import Security
Ok, so I have setup my test environment again. Now I have to create security
all over from scratch to define what will be used in production. Is there a
way to export from the test environment and then import it into the newly
upgraded installation? In both cases security has been/will be completely
removed from the 8.0 install (restored on new server) before being upgraded
to version 10.
Security will be upgraded upon upgrading GP from GP 8.0 SP5 to GP 10.0.
Converting the Security structure from GP 8.0 to 10.0 will not be an easy
Mohammad R. Daoud
MCP, MCBM...Duplicate Personal Folders #3
I have a new workstation w/Outlook 2003. I exported the
pst file from the old machine (Outlook 2000) and imported
the file to this new machine. Now, I have 2 sets of
Personal Folders. They are identical. If I delete an
email or folder from one, it is gone from the other.
Both sets of folders are reading the same data file, so 2
data files isn't the problem. I don't know what to do to
solve this problem.
Thank you in advance!
Elliott Affiliates, Ltd.
By the way, I have done this 5 times in the last week
without this problem happening. Did ever...Export item ID?
Hi there. Having resolved my previous EMS Data import issues, I have
now moved on to more complicated things (importing supplier lists,
aliases etc). However, these operations require the item ID for each
item - something I don't have. Is there some way I can export these
from the database so I know what item ID corresponds to each item. I
have run a query in Administrator (select itemlookupcode, ID from item)
which tells me this, but I haven't worked out how to export this out to
a spreadsheet. Any help would be appreciated, cheers
After running your query goto File menu and Export....Exporting email in Outlook Express
I am unable to export all emails in Outlook Express. First
it had an error message mentioning MAPI so i followed the
instructions on Microsoft Knowledge Base to install
Windows Messaging - now when i try to export the following
error message is: MAPISP32 caused an invalid page fault in
module KERNEL32.DLL at 0187:bff7b9a6.
Does anyone know what this means?
tania jackson <firstname.lastname@example.org> wrote:
> I am unable to export all emails in Outlook Express.
Ask in an Outlook Express newsgroup.
3290 Patterson Ave. SE, MS 1B3
Grand Rapid...SPAM filtering #3
I have Spam filtering on our firewall, third party Spam filtering on the
Exchange 2003 server (TrendMicro ScanMail for Exchange). I understand
Exchange also has IMF and then the Junk mail filter in Outlook. I thought it
might be overkill causing message delivery delays as well as confusing for
users having a Junk Mail folder and a Spam folder (TrendMicro).
Should I (can I?) Globally turn off either of the two MS filters?
Exchange 2003 IMF is not turned on by default. The client can turn on/off
the Outlook Junk E-mail filter, but it is off by default, also.
Ji...Exporting to Powerpoint
I have a small table in Excel that I am trying to export
to PowerPoint, for some inexplicable reason one column was
always missing even though it was specified in the range
which the Macro is supposed to export. My manager is the
only was able to see the value in that column and no other
can replicate his success. Do you know any reason for
this? We are all looking at the exact same file, why
could he see something that the rest of us cannot?
Why don't you simply copy and paste the whole table into a Powerpoin
Message posted from http://www.ExcelForum.com...Email Attachments #3
How can an organization prevent email attachments from being stored in CRM
with the CRM email activity.
Hi Terry, in the System Settings, the CRM admin can block attachments with
defined file extensions (e.g. .exe). To block all attachments you could just
add all the common email attachment file types (.doc, .xls, .pdf, etc.)
Or just set the maximum file size on the E-mail tab to 0KB.
Increase - Hosted Microsoft CRM with Beyond Demand service
> How can an organization prevent email attachments from being stored in CRM
&...Export Image Package
I have an access application that has stored .JPG images within the database
as a "Package". How can I export the image back to a normal .jpg file so
that it can be read by a normal (non ole server) imaging application?
...Export registry key
Is there an API to Export and Extract a registry key in a text format ?
I need to simulate the operation that is done by the user of exporting a key
(and creating a .reg file in a text format).
I do not want to use RegSaveKey/RegRestorekey which work in a binary format.
I believe you will have to do this yourself. There is no Automation or exported function interface
to RegEdit, and that .Reg file concept is a feature of that program. However, it shouldn't be
terribly difficult to do this, using RegEnumKeyEx and RegEnumValue or the CRegKey class, use a
CStdioFile object...Export from Excel to Word
I have a 20 page Excel document that has a LOT of formating involved, it is
text not data. Is there a way that I get it into Word without having to redo
all the formatting? It is 11x17, landscape.
Select the area you wish to copy.
While holding the SHIFT key pull-down:
Edit > Copy Picture...
In the Word document, just paste.
Because you have pasted a picture, the formatting will be preserved. Also
because its a picture, yo can re-size it as you choose.
> I have a 20 page Excel document that has a LOT of formating inv...Reverse of export to database
I would like to generate a Visio drawing starting from an Access
database which contains the results of an 'export to database' of an
existing drawing. I found import possibilities from Excel, csv, txt
files, but not from databases. I'm using Visio 2002 Professional.
Are you trying to import the data from the database tables or the database
If it is the database schema, run the Database modeling template (File \ New
\ Database \ Database model diagram)
If you want to get the data, try the "Link to Database" dialog (Tools \
Macros \ Visio Extras...Export email addresses including aliases
I have a medium organization with 5 different domains so each user has 5 to 10 email aliases. I can't find a way (an easy way) to export all email addresses into a script file so I can create accounts on our off-site anti-spam provider.
DOES ANYONE KNOW HOW TO EXPORT EMAIL ALIASES IN EXCHANGE 2000
Thank you, Shawn.
"Shawn" <email@example.com> wrote:
>I have a medium organization with 5 different domains so each user has 5 to 10 email aliases. I can't find a way (an easy way) to export all email addresses into a script file so I can create accounts on o...Can I export my Publisher document into MS Word?
Does anyone know how I can export my Publisher document
into MS Word?
Hi Matt (firstname.lastname@example.org),
in the Microsoft� newsgroups
|| Does anyone know how I can export my Publisher document
|| into MS Word?
No you cannot. You can open one instance of Publisher and one instance of
Word and copy/paste between the two programs, or do a CTRL+Drag and Drop
between the two programs. Some formatting will be lost however.
Microsoft Office Publisher MVP
Official Publisher MVP Site:
This posting is provided "AS IS" wit...