How do I setup an excel file to import into outlook contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

redletters2 - 30 Aug 2006 21:49 GMT

I have large address books in excel and I want to import them to outlook, but
I am not sure how to go about formating the excel document so that i can
import them into outlook

Reply to this Message

Sue Mosher [MVP-Outlook] - 31 Aug 2006 12:52 GMT

Each address entry needs to be on its own row. Use the Insert | Name command to create a named range that includes all the data and a row of column headings with the field names. Save the file.

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 have large address books in excel and I want to import them to outlook, but
> I am not sure how to go about formating the excel document so that i can
> import them into outlook

Reply to this Message