Importing contact details from Excel

I am trying to import a file from Excel to Outlook contacts. But the
following window keeps appearing: ... the microsoft Excel file has no named
ranges. Use Microsoft Excel to name the range of data you want to import. In
response, I have followed previously provided advice - namely: 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. BUT after doing so, and
starting the import process, I still get the same "the microsoft Excel file
has no named ranges message". I am going around in a circle. All suggestions
would be gratefully appreciated.

did you check to make sure the named range is getting saved? you can check
by looking in the insert name define menu.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:


"JimmyJ" wrote in message
...
I am trying to import a file from Excel to Outlook contacts. But the
following window keeps appearing: ... the microsoft Excel file has no
named
ranges. Use Microsoft Excel to name the range of data you want to import.
In
response, I have followed previously provided advice - namely: 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. BUT after doing so, and
starting the import process, I still get the same "the microsoft Excel
file
has no named ranges message". I am going around in a circle. All
suggestions
would be gratefully appreciated.