Importing Excel files to Outlook contact

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.

"Roy's Wood" wrote:

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" wrote in message
...
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?

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" Roy's wrote in message
...
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.

The .csv worked great! THANKS!

"Karl Timmermans" wrote:

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" Roy's wrote in message
...
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" wrote in message
...

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
--
Brian Tillman [MVP-Outlook]