import excel names & emails help

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

Sue Mosher [MVP-Outlook]

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top