Importing Excel files to Outlook contact


R

Roy's Wood

When importing my data into Outlook (from Excel) for a new contact list I
can't get it to work right. I have assigned names & ranges to the data in the
excel file. Then during the import process in Outlook I mapped where each
name should go. When the list was generated every company name, phone #,
address, contact, etc. become their own Outlook contact with only that 1 line
of info. Please Help.
 
Ad

Advertisements

S

Sally9227

My question exactly....I want it to be converted into a distribution list not
individual contacts. I have about 4000 contacts that I need to divide into
distribution lists and am trying to find the easiest way to do it. Any
advice would be much appreciated. Thank you.
 
G

Gordon

Sally9227 said:
My question exactly....I want it to be converted into a distribution list
not
individual contacts. I have about 4000 contacts that I need to divide
into
distribution lists and am trying to find the easiest way to do it. Any
advice would be much appreciated. Thank you.

I don't think you can import direct to a D/L.
As a secondary point, how many contacts are you expecting to put into each
D/L?
 
K

Karl Timmermans

Your problem is without question related to the Excel Named Range in use -
especially if your statement (......"I assigned names & ranges....) was not
a typo - only <one> named range (versus "names and ranges") should be
applied to all the data that you wish to import.

A very quick alternative if you don't want to deal with <Named Ranges>
1) save your worksheet as a CSV file
2) import the CSV file instead

Karl
______________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer/DataPorter/Exporter/Toolkit
"Contact import/export/data management tools for Outlook '2000/2007"
http://www.contactgenie.com
 
R

Roy''s Wood

The .csv worked great! THANKS!

Karl Timmermans said:
Your problem is without question related to the Excel Named Range in use -
especially if your statement (......"I assigned names & ranges....) was not
a typo - only <one> named range (versus "names and ranges") should be
applied to all the data that you wish to import.

A very quick alternative if you don't want to deal with <Named Ranges>
1) save your worksheet as a CSV file
2) import the CSV file instead

Karl
______________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer/DataPorter/Exporter/Toolkit
"Contact import/export/data management tools for Outlook '2000/2007"
http://www.contactgenie.com
 
Ad

Advertisements

Ad

Advertisements


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