Comparing contacts to an external list of names

D

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 field of
each contact in Outlook with the external list. 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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top