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

**redletters2** · August 30th 06, 10:49 PM posted to microsoft.public.outlook.contacts

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

**Sue Mosher [MVP-Outlook]** · August 31st 06, 01:52 PM posted to microsoft.public.outlook.contacts

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.

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

"redletters2" wrote in message ...
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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import excel file to Outlook Contacts	Hamster	Outlook - Using Contacts	1	August 19th 06 11:04 AM
How do I import an excel file into Outlook Calendar?	Friarrico	Outlook - Calandaring	1	June 21st 06 06:05 PM
import excel file into outlook contacts	crossroads	Outlook - Using Contacts	1	May 9th 06 11:27 PM
How do I setup an EXCEL file to import to Outlook 2003 contact?	Fred Zimnoch	Outlook - Using Contacts	12	April 10th 06 10:09 PM
excel file type missing from import a file window in outlook	xanadufl	Outlook - Using Contacts	9	February 28th 06 10:55 AM