export multiple files Excel to Outlook, only one item appears

[confused]

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?

 

[Sue Mosher [MVP-Outlook]]

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.

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

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