importing from Excel in to contact list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 27 Jul 2005 16:20 GMT

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Jul 2005 16:53 GMT

Check your named range in Excel. It sounds like the E-mail column might not have been included.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have a spreadsheet the was created with the following fields:
>
[quoted text clipped - 10 lines]
> Thanks!
> Jay

Reply to this Message

Jay - 27 Jul 2005 17:41 GMT

OK... that makes a little sense. Can you give me a little more info on how
to do that and what a name range is?

Thanks! I REALLY appreciate the help!
Jay

> Check your named range in Excel. It sounds like the E-mail column might not have been included.
>
[quoted text clipped - 12 lines]
> > Thanks!
> > Jay

Reply to this Message