importing a list of email addresses

  • Thread starter Thread starter i1shear
  • Start date Start date
I

i1shear

can anyone advise me how to import two columns of (1) contact names and (2)
email addresses from an excel spreadsheet into my Outlook Address List?
 
i1shear said:
can anyone advise me how to import two columns of (1) contact names
and (2) email addresses from an excel spreadsheet into my Outlook
Address List?
Click to expand...

File>Import and Export>Import from a program or file
 
#1 - You do not import anything to the Outlook Address Book (list) - you
import info to a contact folder which must be identified as a member of the
OAB - right click on contact folder --> properties --> click on tab for
OAB - make sure checkbox is checked to add folder to OAB..........

#2 - If you are importing from an Excel file - need to make sure that you a
have a valid "named range" for the data you want to import. Not familiar
with "named ranges" - then save the worksheet as a CSV file and import that
file instead (or lookup info re: named ranges in the Excel help file)

#3 - Importing an email address - make sure you map it to the correct field
else you may ask why it didn't work correctly. Manually map the field in
Outlook so that the email address gets mapped to the correct SMTP email
address field (i.e. E-mail Address, E-mail 2 Address, or E-mail 3 Address) -
do not just map it to the E-mail, E-mail 2 or E-mail 3 fields that have the
plus sign next to them - that could work but often doesn't.

Then follow Brian's instructions and all should be just fine using the
Outlook import wizard (from File Menu --> Import/Export etc)

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
 
Back
Top