Comparing external list of names to contact entries?

Status
Not open for further replies.
R

RGFuIFRyaW1ibGU

I have a list of names in an external file. Right now, it's an excel 2003

spreadsheet with separate columns for first name and last name, 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 am not familiar with Outlook's

object model), and don't mind something fairly complicated, but I desparately

need to find some way to do this more efficiently/automated.

Dan
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
You can start with this. Please see the 'set c= ...' line, you need to

complete that yourself. The VBA helpfile explains how to use the Find

function, and there's already an example for searching for the FileAs field.

sub compare()

dim xl as excel.application

dim wb as excel.workbook

dim ws as excel.worksheet

dim rn as excel.range

dim f1 as outlook.mapifolder

dim f2 as outlook.mapifolder

dim items as outlook.items

dim c as outlook.contactitem

set xl=getobject(,"excel.application")

set wb=xl.workbooks(1)

set ws=wb.sheets(1)

set rn=ws.range("a1")

' compare with this contacts

set f1=application.session.pickfolder

set items=f1.items

' move to this

set f2=application.session.pickfolder

while rn.value <> ""

' please complete this yourself...

set c=items.find(...)

if not c is nothing then c.move f2

' move on to the next excel row

set rn=rn.offset(1,0)

wend

end sub

Best regards

Michael Bauer

Am Thu, 26 Mar 2009 10:44:17 -0700 schrieb Dan Trimble:


> I have a list of names in an external file. Right now, it's an excel 2003
> spreadsheet with separate columns for first name and last name, 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 am not familiar with Outlook's
> object model), and don't mind something fairly complicated, but I


desparately
> need to find some way to do this more efficiently/automated.

> Dan
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
cimbian comparing two contacts lists Using Outlook 5
T comparing and subtracting sent and received dates Outlook VBA and Custom Forms 3
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 14
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 16
egarneau Meeting updates with external contacts (GMail) Using Outlook 1
RangerRick Text Extraction from forwarded messages external Exchange Server Administration 1
J HELP- Rule to auto strip prepend from external emails Using Outlook 0
C OWA External Access - No URL / URL Invalid Exchange Server Administration 2
T HTML email for internal mesages and Text only for External? Using Outlook 1
M Separate Internal and external emails in outlook Using Outlook 1
I Outlook 2010 Search Folder criteria for all mails to and from external domain Using Outlook 9
A Change subject line of external software using outlook. Using Outlook 1
B importing Outlook from a backup on an external hard drive Using Outlook 5
P Amend external calendar entries to include internal resources Using Outlook 1
K External Mtg Invitees have =SMTP: added to email address after mtg saved Using Outlook 5
D How to set permissions to allow external program to send an email? Using Outlook 0
M Outlook 2010 is loading many times already received emails from external acc. Using Outlook 4
F How to setup signature with Outlook 2007 with external picture Using Outlook 4
J Assign a signature by external or internal reciepents. Outlook VBA and Custom Forms 1
W email contacts from external contact database. BCM (Business Contact Manager) 1
F Outlook 2007 lose the attatchment when sending through external sc Outlook VBA and Custom Forms 8
M Run external program from Outlook VBA macro Outlook VBA and Custom Forms 5
O Outlook 2010 Add delete button to the side of the message list Using Outlook 1
G Forward email body to other mail list directly from Exchange server Exchange Server Administration 1
N How do I make Outlook autocomplete addresses from a list of recognised <full_names> only? Using Outlook 2
T Outlook 2010 Tasks are not visible in To Do list Using Outlook 5
C must select message to trigger safe list Using Outlook 3
N contact list seen in Contact folder but knot in Address book or when 'TO' button is clicked in new email Using Outlook 0
V Pin a document to the "Attach file" Recent Documents list Using Outlook 0
T Junk Email does not get added to the Blocked Sender List Using Outlook 0
witzker print-list-of-outlook-folders with sort posibility Outlook VBA and Custom Forms 7
F Junk Email does not get added to the Blocked Sender List Using Outlook 4
G Move tasks up/down todo list by VBA Outlook VBA and Custom Forms 1
E Asking user to select multiple options in a list in an email Outlook VBA and Custom Forms 0
C Why won't Title display in message list? Using Outlook 1
T Increasing the number of items that appear on the Categories list Using Outlook 2
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
M Changing the preferred order for "Put this entry in" list for adding new contacts to the Address Book Using Outlook 1
R List folders in a combo box + select folder + move emails from inbox to that folder + reply to that email Outlook VBA and Custom Forms 1
B See "Change View" Drop Down as a List? Using Outlook 1
B How to show concatenated categories in list task view? Using Outlook 2
M How can we find the list of users who are members of a deleted distribution list? Exchange Server Administration 2
B Outlook 365 - Folder pane list clears Using Outlook 28
B All imported tasks appear in to-do list Using Outlook 3
W Remove specific contacts from contact list Outlook VBA and Custom Forms 3
GregS 2016 Contact List being managed by Outlook.com? Using Outlook 1
B Outlook - Mail from safe senders list being sent to Spam Folder Using Outlook 0
M Message list font changed after update Using Outlook 2
A Order of Recent Items in Attach File List Using Outlook 5

Similar threads

Top