Importing from Excel in to outlook

[Guest]

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

 

[Nick Hodge]

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. (Edit>Name>Define...)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)