contact import into outlook 2002 from excel 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prumrip - 29 Dec 2004 04:47 GMT

When I follow the above proceedure and name the ranges in excel in columns
and the records are in rows. I then map the ranges ti the correct field in
outlook ( ie: bussiness address in excel to bussiness address in outlook )
The ranges are imported into outlook in single contact records (Ie: bussiness
address is the only thing in record ). Each mapped item is its own contact
record, they are not in the same record as the row in excel. What is wrong
in my excel range names, or mapping into outlook?

Reply to this Message

Karl Timmermans - 29 Dec 2004 16:56 GMT

Likely cause of problem is incorrect assignment of the Excel "named ranges".

You only need to assign ONE Excel named range that covers all columns and
rows that you want to import (including the first row with your column
names).

Failing that - simply save your file in .CSV format and import that file
into Outlook.

Karl

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

> When I follow the above proceedure and name the ranges in excel in columns
> and the records are in rows. I then map the ranges ti the correct field
[quoted text clipped - 7 lines]
> wrong
> in my excel range names, or mapping into outlook?

Reply to this Message