How do I import a contact list from excel into outlook?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MaryBethK - 01 Nov 2006 23:28 GMT

I have my excel file set up and have a translator loaded but it tells me that
I cannot use the file. I am trying to name the ranges and its not letting me
do anything. How do I get it to name the ranges so I can import the data in
my contact list?

Reply to this Message

Karl Timmermans - 02 Nov 2006 02:53 GMT

Since your prime objective is to import your data - just save the worksheet
as a CSV file and import that file - a lot less aggravating if your not
comfortable with Named Ranges.

Quick process to add a NR

1 - Open Worksheet
2 - Highlight all rows/columns you want to import starting with the first
row (which should have your column headings <field names>)
3 - From menu bar --Insert --> Name --> Define - enter a name
4 - Save worksheet and import the workshhet it in Outlook using the name you
just entered if your asked to make a choice

Karl
_____________________________________________________________
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com

>I have my excel file set up and have a translator loaded but it tells me
>that
[quoted text clipped - 3 lines]
> in
> my contact list?

Reply to this Message