To overcome this place the worksheet with the contacts first in line and Outlook
should assume that is the data to import.

Otherwise, on the sheet with the contacts, select the entire range and
InsertNameDefine.

Give it a name like MyList and OK.

Save the workbook and try again with the import.


Gord Dibben MS Excel MVP

On Tue, 6 Nov 2007 08:58:01 -0800, Katelyn
wrote:

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