Importing from Excel into Outlook

**Rod** · August 18th 06, 04:35 PM posted to microsoft.public.outlook

When I import a contact list from Excel into Outlook it is treating each
line of the address as a separate contact instead of putting them all
together into one contact. Does anyone have any suggestions on how to fix
this?

**Sue Mosher [MVP-Outlook]** · August 18th 06, 05:08 PM posted to microsoft.public.outlook

You need to use the Insert | Name command to create a single named range to cover all the data you want to import. Then make sure you map the fields to the right Outlook properties.

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

"Rod" wrote in message ...
When I import a contact list from Excel into Outlook it is treating each
line of the address as a separate contact instead of putting them all
together into one contact. Does anyone have any suggestions on how to fix
this?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing meetings into Outlook using Excel	Victor	Outlook - Calandaring	1	October 10th 06 04:56 PM
Problems importing Excel to Outlook Contacts	Jim	Outlook - Using Contacts	3	August 8th 06 07:09 AM
importing an Excel document to Outlook Calendar	SANMAN07	Outlook - Calandaring	1	July 21st 06 07:45 PM
Importing Outlook Contacts via Excel	John Harris	Outlook - Using Contacts	1	July 19th 06 11:32 AM
Outlook 2003 when importing from Excel	Renae	Outlook - Using Contacts	4	March 4th 06 03:41 AM