importing e mail addresses from excel

J

jordiman

I have an excel file with contact details and email addresses in
list,
ie column a = name, b= e mail address, is it possible to import thi
into outlook so they are usable directly to address mail....i
contacts/address book etc.....thank
 
K

Karl Timmermans

#1 - From File Menu - Import/Export proceed accordingly (click on <Map
Custom Fields> to ensure that the fields are correctly assigned.

#2 - For Email Address - select Email Address (sub element of Email) to map
to

#3 - If you don't have or are not familiar with Excel "Named Ranges" - save
your worksheet as a CSV file and import that instead

Follow the above and you should have absolutely no problems getting your
data into Outlook.

Karl
--
____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr
"Contact import/export/data management tools for Outlook '2000/2010"
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

Similar Threads

Merging from an Excel file with graphics 1
Lost Address Book 10
A way to mail merge from excel into a word label template? 0
How to Show Nicknames Only in AutoCompleted E-mail Addresses 12
Blast E-Mail 3
Outlook 2010 imported emails from Windows mail - No sender emailaddress available 0
Outlook 2003 Contacts and Email Addresses 8
Outlook 2007 - Fax -> e-mail issue 5

Top