importing excel contact list to outlook
 

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

importing excel contact list to outlook
 

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

importing excel contact list to outlook
 

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