A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

export multiple files Excel to Outlook, only one item appears



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 3rd 06, 09:12 PM posted to microsoft.public.outlook.contacts
confused
external usenet poster
 
Posts: 33
Default export multiple files Excel to Outlook, only one item appears

When I exported a file from Excel to Outlook, I got one set of contacts with
e-mail only, a second set with name only, etc. How do I get Outlook to
associate the names, e-mails and other information together and put each
person's full contact information in one card?
  #2  
Old May 3rd 06, 10:08 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default export multiple files Excel to Outlook, only one item appears

Before you import it, you must set a named range in the Excel file that covers all the columns and rows you want to import. Then during the import, you should use the Map Custom Fields option to tell Outlook which field should contain the data from which worksheet column.

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

"confused" wrote in message ...
When I exported a file from Excel to Outlook, I got one set of contacts with
e-mail only, a second set with name only, etc. How do I get Outlook to
associate the names, e-mails and other information together and put each
person's full contact information in one card?

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Calendar from outlook to Excel with Dates in columns Andreb Outlook - Calandaring 1 March 21st 06 08:14 PM
Export DL members to Excel CSV with Outlook VBA [email protected] Outlook and VBA 0 March 17th 06 09:04 PM
Export Excel to Outlook Contacts Kerri Outlook - Using Contacts 1 March 8th 06 09:43 PM
cant change outlook into cvs files for export. no file HAVE 2 DIS SLATS72 Outlook - Using Contacts 1 March 3rd 06 11:00 AM
How do I export contacts to excel with multiple user defined fiel. James Outlook - Using Contacts 3 February 10th 06 09:50 PM


All times are GMT +1. The time now is 01:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.