Hi again,

Mentioned in another post that I'm working on a method
for converting entries sent from a web mailto form into Contacts.

I've been looking for many hours for some simple open-source
VBA code that doesn't delete duplicate contacts, but
attempts to merge missing information into whatever is
the "best" instance of that contact. Am wanting the
code rather than an add-in, because I'll want to modify it.

Using the emailAddress fields as primary keys, would
I have to check each Item.Email1Address against every other,
get a collection of "hits," and then call a routine for
merging them? I'd probably have to use the entryID
property to track each, because deleting an item will
change its numbering in the collection, right?

The problem with this method is that it seems really
time-consuming (even for a computer!) to check every
contact against every other. I've toyed with the idea
of exporting an entire Contacts folder to Excel, sorting
it on the Email1Address field (for example), and using
an Excel routine to consolidate contact info. Doing it
this way would speed things up because all the duplicates
would be adjacent to each other.

But there must be a more elegant way to do this.

Regards,
mvsmith