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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Misstine - 07 Nov 2005 22:19 GMT

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!

Reply to this Message

Milly Staples [MVP - Outlook] - 08 Nov 2005 07:16 GMT

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.

Signature

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!

Reply to this Message

Karl Timmermans - 08 Nov 2005 16:08 GMT

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

> 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!

Reply to this Message