Importing Excel to Cont, & it won't import all, just 86 of 215

[Misstine]

I'm trying to import contact info from an excel spreadsheet to outlook
contacts. There are 215 contacts, but it will only import 86 of them. I can't
figure out why. I've searched microsoft help, but I'm not able to locate any
answers. HELP!

 

[Milly Staples [MVP - Outlook]]

Export your contacts to Excel. Compare the file to your file and massage
it. Chances are, you are trying to import custom fields, which OUtlook does
not support.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Misstine asked:

| I'm trying to import contact info from an excel spreadsheet to outlook
| contacts. There are 215 contacts, but it will only import 86 of them.
| I can't figure out why. I've searched microsoft help, but I'm not
| able to locate any answers. HELP!

 

[Karl Timmermans]

Check your named range within Excel to make sure that it covers all your
data rows including the first header row. Likely cause of your problem is
that the named range is incorrectly set for the first 86 rows.

Karl

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com