Guessing here as I've come across something similar with mail merge from
Excel to a 3rd part application, but I've never tried to import from Excel
to Outlook.

It's possible that Outlook can't determine exactly where your data is on
it's own (ie, what worksheet and cell range).

In Excel, select all your data then go to Insert Name Define. In the
"Names in workbook" field, enter a suitable name for the range eg
ContactData (note you can't have spaces and certain other characters in a
Name).

Save the file and try again with Outlook.

Good luck.

Ian

"Katelyn" wrote in message
...
I have a contact list saved in an excel file. I tried to import that
contact
list to Microsoft Outlook by doing the following:

1. Clicking on File in Outlook.
2. Clicking on Import and Export.
3. In the Import and Export Wizard, clicking on Import from another
program
or file.
4. In the Import a File window, clicking on Microsoft Excel.
5. Going to Browse and clicking on the saved contact list file and
selecting the Replace duplicate option.
6. Selecting Contacts as my destination folder.

Then I receive an error that states: "The Microsoft Excel file has no
named
ranges. Use Microsoft Excel to name the range of data you want to
import."

I tried to figure out how to do that by looking up name ranges in Help,
but
I couldn't understand exactly what it is I should do.

If anyone could help me with this problem I'd really appreciate it.

Thanks,
Kate