importing info from Excel into outlook contacts

[Bob Brown]

I have a good healthy list in my outlook contacts now. I need to import
another list from excel. The outlook list is mostly email numbers. The
excel list is all names and addresses. Can I import the excel list and have
them merge into the two under each contact.
For instance ...for example.:
Harry Smith's email number is in outlook
Harry Smith's street address is in excel

How do I import excel and have the street address added to the record with
the same name that the email number is in.

 

[Karl Timmermans]

The only option you have available via Outlook's import process is "Replace
duplicates with items imported" and to be honest, it's a process that seems
to be prone to errors as in "failing to run" more often than not (at least
in our tests - may very well be different for others). Make a backup of your
PST file and see how it works for you.

Alternatively, you may find ContactGenie DataPorter - (Pers Ed) of interest
which will allow you to import (and update) existing contacts -
http://www.contactgenie.com/cg20features.htm (there is a very inexpensive 15
day license available for one off requirements)

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

 

[Diane Poremsky [MVP]]

if the name and email match, outlook should detect the records are matching
and offer to update. See http://www.slipstick.com/addins/contacts_dups.asp
for duplicate removers - contact scrubber is one utility that will match
contacts and let you pick the fields to keep from each record.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.