comparing two contacts lists

Not open for further replies.


Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I run my own business and have my own contacts in Outlook but recently I began to subcontract to another firm and we merged our two lists into one.

Before doing this I set categories to show the source of the contact.

What I would like to do now it to run some kind of query against the two original lists and generate three outputs (could be additional categories):

Unique to my list

Unique to their list

Common contacts

Any thoughts on how to do this?


Outlook 2010 32BIT
Bumping this question but for Office 365 Outlook.

I have my primary contact list, and another that I have mailed and cleansed. I don't want to use an automerge as this has caused me many, many problems in the past but would like to compare the two and manually change my master list.
You have a couple of options:

Create a view that shows only those contacts in category 1. Use a list view (like phone number view), remove the fields you don't need, select all, copy and paste into Excel. Repeat with the other category. If you just want to look at them in outlook and get totals etc, you can save the filtered views and apply them as needed. Views only work on one folder at a time, but you can do a category search instead.

Or, skip the two filtered views and either export to excel or select all, copy and paste into Excel - then work with the data in excel. If you use multiple folders, repeat it for each folder.
Thanks, Diane.

I was hoping to code something but I guess Excel is the right way to go as it's a one-off job (I hope). :)
Even if its not one off, it might still be faster to work in Excel - the time you spend testing it could negate any savings. And yes, i've written macros that weren't very 'cost effective' - because the fun of doing something sometimes outweighs everything. :)

Basically, what you want is a macro that lists (or counts) all contacts in cat1, then all in cat2, and a list of all in both categories? For that, filters and view should work - and keep you in outlook. It you need more data massaging, excel.

This should show all contacts in the category:

and all in both these:
category:=("category") AND category:=("Green")

Totals will be in the status bar. It will be faster than using a macro to count - and if you need and the search criteria is replaced by new MRU searches, you could use a macro to set the search.
Thanks. And, yes, I have also got carried away with coding just for the fun of it.

Appreciate the help. :)
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
T comparing and subtracting sent and received dates Outlook VBA and Custom Forms 3
R Comparing external list of names to contact entries? Outlook VBA and Custom Forms 1
G Apply Custom Contacts form to all existing Contacts Outlook VBA and Custom Forms 1
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
B Sync Outlook Public Folders to Contacts Using Outlook 2
Kika Melo How to mark as Junk any message not from Contacts (in Using Outlook 3
G Outlook 365 My iCloud Outlook doesn’t work after reinstalling Microsoft365 on Windows 10 PC – now I get error message on contacts and calendar Using Outlook 1
T How to Export & Import GMAIL Contacts into Outlook 2021 ? Using Outlook 4
L Applying new form to existing contacts -- MessageClass Outlook VBA and Custom Forms 3
Bardiferous Weird Contacts Behavior - Can't find any in any address book, but they're in there Using Outlook 3
S client lost 3K contacts when office 365 for mac account deleted from company exchange server Using Outlook 5
O How to sync (one way) contacts between two Outlook (exchange) accounts? Using Outlook 0
P How to clear out all contacts in iCloud, so I can use iCloud-based sync program Using Outlook 1
R How to prevent corrupted Notes format in Calendar and Contacts Using Outlook 0
K Outlook 365 After migrating to Outlook 365, some contacts display in emails with prefixes Using Outlook 0
kburrows Outlook or Phone Combining Contacts? Using Outlook 0
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
G Add contacts birthday to calendar Using Outlook 4
R How to force Outlook to use plain text in notes for Contacts? Using Outlook 1
S Cannot print Contacts Using Outlook 7
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
J Outlook 365 Outlook 2016/365 Contacts Lose Info when Favorited to the To-Do Bar Using Outlook 2
D Advanced e-Mail search on from/to contact group only searches for first 20 contacts in group Using Outlook 0
P Outlook calendar and contacts sync problem-outlook disconnects Using accounts in Outlook 2
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
O Outlook - hidden contacts? Using Outlook 2
H Synchronize contacts and calendars across multiple devices Using Outlook 0
S Outlook 2016 Change how Outlook shows me contacts in emails Using Outlook 0
L Favorites for People/Contacts? Using Outlook 1
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
Horsepower Contacts added from iPhone don't show up in Outlook Using Outlook 2
B oContacts.Items.Restrict Misses Some Contacts Outlook VBA and Custom Forms 3
F Moving Contacts to New Profile Using Outlook 0
V Contacts in O365 have changed?? Using Outlook 20
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
D Outlook Contacts Notes Field Photos to Smartphone Using Outlook 0
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
D Is a sub folder under contacts necessary to be able to name an Address Book? Using Outlook 1
L Outlook 2016 Contacts missing in Outlook 365 Using Outlook 1
L icloud contacts sync Using Outlook 4
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 10
M Changing the preferred order for "Put this entry in" list for adding new contacts to the Address Book Using Outlook 1
GregS Exporting contacts Using Outlook 1
O Synchronising contacts Outlook 365 with Google v.v. Using Outlook 4
J can't sync outlook calendar contacts with iphone ipad Using Outlook 4
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
egarneau Meeting updates with external contacts (GMail) Using Outlook 1
T Outlook Contacts ... Changing Font Size, Style, Bold, etc. Using Outlook 2

Similar threads