PC Review


Reply
Thread Tools Rate Thread

Comparing contacts to an external list of names

 
 
Dan Trimble
Guest
Posts: n/a
 
      25th Mar 2009
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing external list of names to contact entries? Dan Trimble Microsoft Outlook VBA Programming 1 26th Mar 2009 06:12 PM
Comparing an external list of names with contacts Dan Trimble Microsoft Outlook Contacts 1 26th Mar 2009 11:50 AM
comparing names in a list =?Utf-8?B?ZmVyZGU=?= Microsoft Excel Misc 6 22nd Mar 2006 05:11 AM
comparing list of names =?Utf-8?B?Y2pz?= Microsoft Excel Worksheet Functions 2 6th Jul 2004 06:31 AM
Re: Is is possible to return a list of table names in an external Access DB using SQL? Graham R Seach Microsoft Access Queries 2 24th May 2004 12:18 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:09 AM.