Importing from Excel in to outlook

J

Jay

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
 
N

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
[email protected]
 
Top