Import contacts from excel spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon @ Flag Fen - 09 May 2006 12:48 GMT

When I try to import from an excel spreadsheet using wizard, I am only given
three fields from the excel spreadsheet. These being Company, First anme
and surname. As I only needed company and email address I tried moving this
info to be the first two columns but still get the same options up. Help
please.

Reply to this Message

Sue Mosher [MVP-Outlook] - 09 May 2006 13:35 GMT

Check that you have properly defined a named range in the spreadsheet that covers all the columns and rows that you want to import. Then in the Import and Export wizard, click the Map Custom Fields button to tell Outlook which Excel column's data to put in which Outlook field.

Signature

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

> When I try to import from an excel spreadsheet using wizard, I am only given
> three fields from the excel spreadsheet. These being Company, First anme
> and surname. As I only needed company and email address I tried moving this
> info to be the first two columns but still get the same options up. Help
> please.

Reply to this Message