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
 
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
T External email warning banner Outlook VBA and Custom Forms 0
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
K Closing external IMAP email... Outlook 2013 Using Outlook 0
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
farrissf Category list to pick from Outlook VBA and Custom Forms 4
R Outlook 2019 VBA to List Meetings in Rooms Outlook VBA and Custom Forms 0
S Inconsistent view of To-Do List Using Outlook 0
S Different views for To-Do List and To-Do Bar Using Outlook 1
R Adding Userform Dropdown List items from names of subfolders on network drive Outlook VBA and Custom Forms 10
K Daily Task List Minimized Cannot Display Using Outlook 5
S Outlook 2021 Can you make emails from 3 word domains "safe" by entering top 2 word domain into Safe List in Outlook? Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
L Capture email addresses and create a comma separated list Outlook VBA and Custom Forms 5
D VBA code to select a signature from the signatures list Outlook VBA and Custom Forms 3
L Checking Sender Email Address for trusted domain from list on intranet Outlook VBA and Custom Forms 4
NVDon Create new Move To Folder list Outlook VBA and Custom Forms 0
Ken Pascoe Outlook Categories Quick List Using Outlook 0
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

Similar threads

Back
Top