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.


--
Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au



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

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

"Judy Gleeson (MVP Outlook)" wrote:

Try going to Outlook and use the File Import Export wizard to import from
Excel.


--
Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au



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

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



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

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)