Importing from Excel in to outlook
 

I have a spreadsheet the was created with the following fields:

First Name,Last Name,Suffix,Company,Address 1,Address 2,City,State,Zip
Code,Phone,Fax,E-Mail

I am trying to import this list in to Outlook Contacts. When I run the
import wizard and select excel it takes me to the screen to do the custom
mappings. Everything looks great except I do not have the field "e-mail"
listed so I cannot map it to the e-mail field in outlook. All the other
fields show up on the left side of the imports screeds. Any suggestions
would be GREATLY appreciated.

Thanks!
Jay

Jay

Two things to try

1) Rename the e-mail field to email
2) Highlight all the data and name the range Database. Excel likes this when
importing, mailmerging, etc. (EditNameDefine...)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Jay" wrote in message
...
I have a spreadsheet the was created with the following fields:

First Name,Last Name,Suffix,Company,Address 1,Address 2,City,State,Zip
Code,Phone,Fax,E-Mail

I am trying to import this list in to Outlook Contacts. When I run the
import wizard and select excel it takes me to the screen to do the custom
mappings. Everything looks great except I do not have the field "e-mail"
listed so I cannot map it to the e-mail field in outlook. All the other
fields show up on the left side of the imports screeds. Any suggestions
would be GREATLY appreciated.

Thanks!
Jay