Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing from Access error access hacker1 Excel Discussion (Misc queries) 3 September 3rd 08 09:24 PM
Error Importing Web Data Grobin Excel Discussion (Misc queries) 0 September 5th 07 08:22 PM
VBA Error Message "Compile Error...." Steve Excel Discussion (Misc queries) 3 July 15th 05 09:20 AM
changing the message in an error message The Villages DA Excel Worksheet Functions 2 February 18th 05 05:30 PM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 21st 05 11:39 PM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"