Importing Excel data into Outlook 2007

[terrydaw]

I have been trying to import data saved to an excel workbook but when
I go through the normal import process this is what I get as an error
message. Does anyone have the answer as to how to name the data range
in excel??


An error has occurred in the Microsoft excel 97-2003 translator while
getting the contents of a file system.
The microsoft Excel 97-2003 file C:\User\Terry Daw|documents
\Morelsoftware\Sales Force\contact.xls
Has no maned ranges. Use Microsoft 97-2003 to name the range of data
you want to import.

 

[Milly Staples [MVP - Outlook]]

The error message tells you exactly what is wrong - you have no named ranges.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
How to ask a question:
http://support.microsoft.com/KB/555375


After furious head scratching, (e-mail address removed) asked:

| I have been trying to import data saved to an excel workbook but when
| I go through the normal import process this is what I get as an error
| message. Does anyone have the answer as to how to name the data range
| in excel??
|
|
| An error has occurred in the Microsoft excel 97-2003 translator while
| getting the contents of a file system.
| The microsoft Excel 97-2003 file C:\User\Terry Daw|documents
| \Morelsoftware\Sales Force\contact.xls
| Has no maned ranges. Use Microsoft 97-2003 to name the range of data
| you want to import.

 

[Diane Poremsky [MVP]]

You need a named range. See
http://www.slipstick.com/Tutorials/import/import.htm for the steps.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/



EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.