import excel names & emails help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top