To avoid the issue of "Named Range" - just save the worksheet as a CSV file
and import that instead.

If you're going to do this on an on-going basis - one of our products may be
of interest:
http://www.contactgenie.com/cg20features.htm
(will import directly into any contact folder - Exch Mailbox, PubFldrs or
PST. You also have the option with DataPorter to "update" pre-existing
contacts)

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"Marilyn" wrote in message
...
Well, that's what I did - several times. It seems so simple and I don't
get
why it won't work.

"Gordon" wrote:

"Marilyn" wrote in message
...
Judy - I'm having a heck of a time with naming the range. I've been in
Excel
help and on the Excel discussion group. two replies took me to
documents
that basically say the same thing as Excel help. I've taken the
suggested
steps a dozen times and two or three different ways. End result is
still
the
error that the document has no named ranges and to use Excel to name
the
range of data I want to import. Any suggestions? Thanks


All you do is highlight the data and type the name in the box at the top
left hand side of the window, next to the formula bar.....