export multiple files Excel to Outlook, only one item appears

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

confused - 03 May 2006 20:12 GMT

When I exported a file from Excel to Outlook, I got one set of contacts with
e-mail only, a second set with name only, etc. How do I get Outlook to
associate the names, e-mails and other information together and put each
person's full contact information in one card?

Reply to this Message

Sue Mosher [MVP-Outlook] - 03 May 2006 21:08 GMT

Before you import it, you must set a named range in the Excel file that covers all the columns and rows you want to import. Then during the import, you should use the Map Custom Fields option to tell Outlook which field should contain the data from which worksheet column.

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 exported a file from Excel to Outlook, I got one set of contacts with
> e-mail only, a second set with name only, etc. How do I get Outlook to
> associate the names, e-mails and other information together and put each
> person's full contact information in one card?

Reply to this Message