import Excel to Outlook, each field importing as separate contact

[ozbrandi]

I am trying to import contact data from Excel to Outlook. Records are
arranged in Rows, with column headings for Name, Email etc, but when it
imports it is importing each individual data field as a separate contact.
Help!

 

[Sue Mosher [MVP-Outlook]]

Did you create a single named range for the rows and columns you want to import? DId you double-check the field mapping?

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

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

 

[Nancy]

I am having the same problem. I have gone through the instructions more than
5X and still the same thing happens. I have verified the name range, made
sure all of the mapping is correct and the data still comes out as individual
contacts.
Any additional help would be greatly appreciated.

 

[Sue Mosher [MVP-Outlook]]

Do you get a different result if you save the data to be imported as a ..csv file and import that file instead of the spreadsheet?

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

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

 

[Nancy]

That worked!!!!
Thank you so much!!!!

Do you get a different result if you save the data to be imported as a ..csv file and import that file instead of the spreadsheet?

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

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