How do I export an Excel list to a contacts distribution list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I exported an Excel list as CSV into an Outlook 2002 Dirtibution list and
lost all the Excel fields exceot the name and job titles. L ots addresses,
city, email field, etc. How do I tell Excel to export all the fields or how
do I tell Outlook to import them all?
Thanks for the help,

Victor Hayes
 
Try going to Outlook and use the File Import Export wizard to import from
Excel.
 
I am trying to use the File Import/Export wizard and I keep getting an error.
I select my file to import,
select "do not import duplicate items"
click "next"
Select my destination folder "Contacts"
click "next"
I then get a translation error: An error has occurred in the Microsoft
Excel translator while getting the contents of a file system. The Microsoft
Excel fiel "C:\Documents and Settings\dmeyer\Desktop\ER email list.xls" has
no named rages. use Microosft Excel to name the range of the data you want to
import.

I read on another posting that you didn't need to select the range, so I
guess I am confused as to how to get this done.

Thanks
 
Noel said:
I am trying to use the File Import/Export wizard and I keep getting an
error.
I select my file to import,
select "do not import duplicate items"
click "next"
Select my destination folder "Contacts"
click "next"
I then get a translation error: An error has occurred in the Microsoft
Excel translator while getting the contents of a file system. The
Microsoft
Excel fiel "C:\Documents and Settings\dmeyer\Desktop\ER email list.xls"
has
no named rages. use Microosft Excel to name the range of the data you want
to
import.

I read on another posting that you didn't need to select the range, so I
guess I am confused as to how to get this done.
Click to expand...


Your error message has the clue. If you are importing from an Excel
Workbook, (*.xls) then you MUST name the data range, otherwise you get this
error message.
An easier answer if you don't know how to do that is to open the Excel
Workbook and do File-Save As and save it as a *.csv file and import that.
CSV files don't need a named range to import into Outlook..
 
Back
Top