Importing Excel files to Outlook contact

  • Thread starter Thread starter Roy's Wood
  • Start date Start date
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.
 
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.
 
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.
Click to expand...

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?
 
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
 
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
Click to expand...
 
Back
Top