ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Error message when importing to Outlool (https://www.excelbanter.com/excel-discussion-misc-queries/222591-error-message-when-importing-outlool.html)

djungst

Error message when importing to Outlool
 
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?

Sheeloo[_3_]

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?


Ron de Bruin

Error message when importing to Outlool
 
For Outlook see
http://www.rondebruin.nl/mail/importcontacts.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




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



All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com