import excel names & emails help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris at the Inn - 16 Mar 2006 01:15 GMT

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.

Reply to this Message

Sue Mosher [MVP-Outlook] - 07 Apr 2006 21:02 GMT

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.

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

> 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
[quoted text clipped - 5 lines]
> containing the full name and email. How do I solve this...keeping in mind my
> excel database contains 1500 contacts.

Reply to this Message