View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

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