View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Error message when importing to Outlool

First row of you Excel file should have lables or headers...

If they are not what the Outlook expects them to be then you can map them to
the labels expected by Outlook.

You can export from Outlook to see the format... You can use the same to
prepare your data and import into Outlook.

"djungst" wrote:

I am getting the following error message when I try to import to Outlook from
an Excel file. I do not know if it is an Outlook problem or an Excel problem.

"An error has occurred in the Microsoft Excel translator while getting the
contents of a file system.

The Microsoft Excel file C:\data.xls has no named ranges. Use Microsoft
Excel to name the range of data you want to import."

I have looked at the file and all columns have a name associated with them.
Can any one help with a possible solution?