Importing excel file into outlook

[kcwoodard]

I imported an excel file into outlook. Half of the files showed up in my
contacts, but the half didn't. I can't figure out why only half worked.
There is no change in information between those imported and those not.

 

[Sue Mosher [MVP-Outlook]]

The most likely explanation is that your named range covered only half the rows.

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

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

 

[kcwoodard]

So how do I change the range to include all of the contacts

 

[Milly Staples [MVP - Outlook]]

Create a few contacts in Outlook and export to Excel. Compare Outlook's
output and your own and massage your file accordingly.

--
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, kcwoodard asked:

| So how do I change the range to include all of the contacts
|
| "kcwoodard" wrote:
|
|| I imported an excel file into outlook. Half of the files showed up
|| in my contacts, but the half didn't. I can't figure out why only
|| half worked. There is no change in information between those
|| imported and those not.