Importing contacts into outlook from excel

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

I have a list of contacts in excel and have tried several times to
import the info into outlook contacts.

I have named the ranges in Excel and yet when I import the data it
puts each line of the address and phone numbers etc. in as seperate
contacts, where can I find more information and help on how to do
this?
 
"named the ranges"? You need only one named range, unless you are importing
multiple data sets from a single workbook. The range must encompass all the
rows and columns that you want to import.
 
Sue Mosher said:
"named the ranges"? You need only one named range, unless you are importing
multiple data sets from a single workbook. The range must encompass all the
rows and columns that you want to import.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Click to expand...


Thanks I have now just the one range and when I try now I get all the
name and address at once and map to the required fields in Outlook,
then when I click on finish it seems to do something but nothing is in
the contacts folder.
 
Try importing to a different folder, one that you create especially for this
purpose. If that works, move the items into the Contacts folder and check
that folder for a filter.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Liz said:
"Sue Mosher [MVP-Outlook]" <[email protected]> wrote in message
"named the ranges"? You need only one named range, unless you are importing
multiple data sets from a single workbook. The range must encompass all the
rows and columns that you want to import.
Click to expand...
Click to expand...
 
Back
Top