How do i name a range of data in excel

S

scooter

I am trying to import contact information from an excel 2003 spreadsheet to
outlook. When I go to outlook to import the information it says "an error
has occured in the microsoft excel translator while getting the contents of
file system. The excel file has no named ranges. Use excel to name the
range of data you want to import"

I do not know how to name the range of data in exel, no matter what I try to
do.

Can someone please tell me how to do that?

Thanks
 
P

Peo Sjoblom

It's better to save the Excel file as *.CSV, then import as a comma
separated value (windows) file.

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't get an Excel spreadshe doc. to export into Oultook Contacts 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
name the range of data 3
Conditional formatting on a dynamic range - workaround 1
Access Subscript out of range when importing into access 2010 from excel 0
Contacts from Excel to Outlook 1
How do you name "range" of data to import/export? 2
excel97-03 into Outlook Contacts 2

Top