Comparing an external list of names with contacts

[Dan Trimble]

I have a list of names in an external file. Right now, it's an excel 2003
spreadsheet, but I can just as easily put it into Access, Word, text/CSV,
etc. Each name on the list corresponds to a contact in Outlook -- or it
might not (some don't exist, and don't need to).

I need a script or program that will compare the names *OR* File As fields of
each contact in Outlook with the external list. It does not need to search
any field other the names fields. If it doesn't exist, it can move on to the
next one. But if a contact entry in Outlook DOES exist for that name, I need
it to move the contact to another Outlook contacts folder. Or, at the very
least, flag it or assign it to a category. Then I could always filter on
that flag or category and move all of them at once by hand.

I've been doing this manually, one by one, and I'm tired There's about
3,800 names to get through, and I'm only on 1,219--after several hours of
doing this.

Anyone have any suggestions on how this can be done more efficiently? Is
there a script or program that can do it? I'm very technically inclined
(used to program, but it's been years), and don't mind something fairly
complicated, but I desparately need to find some way to do this more
efficiently/automated.

Dan

 

[Brian Tillman [MVP - Outlook]]

I have a list of names in an external file. Right now, it's an excel 2003
spreadsheet, but I can just as easily put it into Access, Word, text/CSV,
etc. Each name on the list corresponds to a contact in Outlook -- or it
might not (some don't exist, and don't need to).

I need a script or program that will compare the names *OR* File As fields
of
each contact in Outlook with the external list.

I can't tell you if such a script or program exists, but you might get a
response by asking in one of the programming newsgroups, either
microsoft.public.outlook.program_vba or .program_addins. You might also want
to visit http://www.slipstick.com/addins/contacts.asp and
http://www.outlookcode.com/