Importing excel file into outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kcwoodard - 28 Oct 2005 21:40 GMT

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.

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Oct 2005 22:56 GMT

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

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

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

Reply to this Message

kcwoodard - 28 Oct 2005 23:09 GMT

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

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

Reply to this Message

Milly Staples [MVP - Outlook] - 29 Oct 2005 06:19 GMT

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

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

| So how do I change the range to include all of the contacts
|
|| 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.

Reply to this Message

Rate this thread: