|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
March 16th 06, 12:15 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
import excel names & emails help
My excel list contains first names, last names and emails. The corresponding
first name, last name and email are in a row. The first column contains all the first names, the second all the last names and the third all the emails. The columns/fields are named. When I import the list into Outlook Contacts, it imports each the first name, last name and email as a separate contact...not as one contact containing the full name and email. How do I solve this...keeping in mind my excel database contains 1500 contacts. 
|
|
#2
April 7th 06, 09:02 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
import excel names & emails help
Make sure your named range in Excel covers all 1500 rows and that you use the Map Custom Fields option on Outlook's Import and Export Wizard to tell Outlook which field to use to store each Excel 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 "Chris at the Inn" wrote in message ... My excel list contains first names, last names and emails. The corresponding first name, last name and email are in a row. The first column contains all the first names, the second all the last names and the third all the emails. The columns/fields are named. When I import the list into Outlook Contacts, it imports each the first name, last name and email as a separate contact...not as one contact containing the full name and email. How do I solve this...keeping in mind my excel database contains 1500 contacts.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Import of excel file emails into microsoft outlook | Lim | Outlook - Using Contacts | 1 | February 24th 06 01:59 PM |
| Lost my contacts & now company names don't display | tester2500 | Outlook - Using Contacts | 3 | February 2nd 06 09:04 PM |
| Can you import contacts from Outlook to Excel, Access, Word &how? | ericsayang | Outlook - General Queries | 1 | February 2nd 06 06:39 PM |
| import contacts from excel | LSChaefer33 | Outlook - General Queries | 1 | January 18th 06 09:38 PM |
| import excel spreadsheet names emails addresses to distribution l | Mary | Outlook - Using Contacts | 1 | January 16th 06 08:26 PM |
Hybrid Mode
