how do I import contacts in excel with email addresses included?

R

riemster1

need help. I imported my contacts from excel to Outlook contacts but the
email addresses from my contacts did not appear in the Outlook Contacts.
 
A

Adrian

check the named range in excel extends to the email address column - see Ben
M Schorr's answer to my similar question below - "Problem importing contacts
from excel 2003 to outlook 2007"
 
K

Karl Timmermans

There are 3 different things off the top that need to be checked

#1 - Your Excel named range as noted in the response from Adrian but in this
particular case, doubt the "named range" is the problem unless your email
addresses are in the last column not covered by the named range

#2 - Did you manually map your fields or let Outlook <AutoMap> and expect
the field to be mapped correctly (depending on auto-map is a leading cause
of things not getting imported)

#3 - If you manually mapped the fields - what field exactly did you map the
Email Address to? What other email fields did you map (i.e. Email Address
Type). If your email addresses are simple SMTP addresses - should be mapped
to <Email Address> (or <Email 2 Address> etc) and should let Outlook fill in
the Address Type field.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 

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