Jocelyn: Did exactly as you suggest, no avail? I have imported dozens of
Excel spreadsheets into Microsoft Outlook in the past with no problem, but no
matter what I do I continue to get the same error message as okii? Can't
understand it, wasted 3 hours today trying to figure it out!!! VERY
frustrating, what do you suggest, keep getting the same stupid error message,
that my Excel spreadsheet on contacts has "no named range" ????? It goes on
to say Use Microsoft Excel 97-2003 to name th range of the data you want to
export."

Microsoft programmers are such geniuses! If I upgraded to 2007, how can I
make the changes in 97-2003. This 2007 Upgrade is truly the most retarded
upgrade to date. This is one of the many problems I have had which were
NEVER problems before in the older version.

Anyone have an answer to this current issue, the one stated here does not
work.

"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1 to
J12) and while that block is selected, type a name for the range in the box
above the grid, to the left of the formula bar (it usually has a cell number
in it and if you hover over the box it should say Name Box). Now save and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???