import contacts from Excel sheet into Outlook contacts folder

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ras - 15 Jan 2005 07:03 GMT

Whenever I try to import my Excel contact list into MS Outlook, it keeps
giving me an error msg when I am in the migrattion process: " The MS Excel
file C:\........" has no named ranges. Use MS Excel to name range of data you
want to import"

Pls help..

Reply to this Message

Sue Mosher [MVP-Outlook] - 15 Jan 2005 15:41 GMT

You need to do what the message says: Open the list in Excel and create a
named range. Select the cells that contain the data you want to import, then
choose Insert | Name | Define.

Signature

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

> Whenever I try to import my Excel contact list into MS Outlook, it keeps
> giving me an error msg when I am in the migrattion process: " The MS Excel
[quoted text clipped - 3 lines]
>
> Pls help..

Reply to this Message