importing from Excel - getting one field per record

[KevinHenck]

When I attempt to import from Excel into outlook contacts. I get one field
per record. It doesn't seem to keep rows together and put them in one
contact record.

 

[Sue Mosher [MVP-Outlook]]

Sounds like you might not have either the named range in the worksheet or the mapping set up correctly. THe named range needs to cover all the rows and columns of the data you want to worksheet. And in the Import and Export wizard, you should click the Map Custom Fields button to confirm that the columns are being mapped as you want to appropriate Outlook fields.

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

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