help with excell to outlook for mail merge
 

i can't seem to get my contacts from excell to outlook so i may do a mail merge

Hi

i'm a bit confused - where are your contacts now - Outlook or Excel and what
program are you trying to do a mail merge with - Excel, Outlook or Word.

Also please let us know what version you're using of the software (help /
about in any of the abovementioned products).

Cheers
JulieD

"gripon" wrote in message
...
i can't seem to get my contacts from excell to outlook so i may do a mail
merge

See JulieD's post for other pertinent questions.

If all you want is to move a list of contacts from Excel to your Outlook
address book Contacts list................

This is how I do it.

The basics........Your layout may differ. Instructions here are for Name and
Email address only, but adjust to suit for more columns.

First have the names and email addresses in Excel in two columns.

I set up also a third column with the names duplicated so when you Import to
Outlook you have a name for the Contact and a Display Name instead of the
email address in the To: box.

FileSave AsFile Type CSV(comma delimited)(*.csv)

Now open Outlook and FileImport/ExportImport from another fileComma
Separated Values(Windows)NextFile to Import(you can browse to your saved
*.csv file). Next you will be asked where to import them to. I bring mine to
"Contacts".

Follow the instructions and you will get a Map. Drag your names and addresses
to the appropriate spots on the Map

1. Name of Contact
2. Email address1
3. Display Name(if you have one by making the duplicate column mentioned
earlier). If not, the email address wil be displayed in the To: box.

Continue with the OK's until Outlook pulls all from the *.csv file(should take
only a few seconds).

Now they are in the Contacts folder, you can group them as you wish.


Gord Dibben Excel MVP

On Mon, 14 Mar 2005 07:35:05 -0800, gripon
wrote:

i can't seem to get my contacts from excell to outlook so i may do a mail merge