excel contact list to outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ry - 24 Jul 2003 19:41 GMT

when i import the list from excel into outlook - excel
gives me an error that says "it does not recognize the
ranges"..also, when i manually cut and paste email
addresses into the bcc window for an outgoing mail it
gives me an error that says "it does not recognize the
contact". does anyone know a workaround without having to
manually enter the contacts into my outlook?

Reply to this Message

Sue Mosher [MVP] - 29 Jul 2003 13:29 GMT

The data needs to be in rows, one per contact entry. The named range needs to cover all the rows, plus the column headings.

Signature

Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm

> when i import the list from excel into outlook - excel
> gives me an error that says "it does not recognize the
[quoted text clipped - 3 lines]
> contact". does anyone know a workaround without having to
> manually enter the contacts into my outlook?

Reply to this Message