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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Anything will help 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Importing Text from Outlook into Excel 5
importing from Excel in to contact list 2
import problems 0
import and other problems 0
How to import Start/Finish Data from Excel 1

Top