importing excel contact list to outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Katelyn - 06 Nov 2007 16:59 GMT

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

Reply to this Message

Karl Timmermans - 06 Nov 2007 17:18 GMT

A very simple alternative approach to importing your data..........

Save your Excel worksheet as a CSV file. Import that file into Outlook
instead of your Excel file.

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

>I have a contact list saved in an excel file. I tried to import that
>contact
[quoted text clipped - 23 lines]
> Thanks,
> Kate

Reply to this Message

Edward - 06 Nov 2007 22:47 GMT

Well, you don't really have to resave the Excel file with CSV format. You
need to define a name range in your Excel files ( very trivial task) , select
the entire area in your Excel worksheet that contains the data (all records
and fields-also make sure to select the first row that usually has the lable
for each field- if fields don't have names you need to add lable for each
field ) and then either simply type a name in namebox(top left corner of
spreedsheet which usually shows A1-and Enter) or go to insert\name\define
and type a name for the selected range. this way after the last step outlook
will show you the name range you defined in Excel and knows where to import
data from.

Signature

Best regards,
Edward

> A very simple alternative approach to importing your data..........
>
[quoted text clipped - 36 lines]
> > Thanks,
> > Kate

Reply to this Message