excel to outlook error

S

Steve

I am importing my excel contact list to outlook, however, Each column is
apprearing as a separate contact.

How can I map each line item to be one contact?
 
S

Sue Mosher [MVP-Outlook]

Define a single named range covering all the data you want to import, save the Excel file, and in the Import and Export wizard, use the Map Custom Fields command to tell Outlook which column to put in which proeprty.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
R

Rod

Sue Mosher said:
Define a single named range covering all the data you want to import, save the Excel file, and in the Import and Export wizard, use the Map Custom Fields command to tell Outlook which column to put in which proeprty.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Thanks for the info. It worked beatuifully.
 
Top