Importing Excel files to Outlook contact

[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.

 

[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.

 

[Gordon]

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?

 

[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

 

[Roy''s Wood]

The .csv worked great! THANKS!

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

 

[Brian Tillman [MVP - Outlook]]

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.

You can't import into a DL. See this:
http://www.slipstick.com/Tutorials/create/dl.asp