Combine Duplicate Contact Items

Last reviewed on December 8, 2011

Starting with Outlook 2000, if you create an entry in a Contacts folder that matches an existing entry, Outlook asks whether you want to merge the information, ignore the new contact or save it as a new contact anyway.

There are tools (listed below) which will merge the data on duplicate contacts to one contact. This is useful if you are combining contact lists from different computers and the data on the contacts are not identical.

In Outlook 97 and 98, there is no built-in way to merge such duplicate records. You must make field-by-field comparisons to decide what needs to be updated in each record. An alternative method would be to code VBScript on an Outlook form to look for items with duplicate names and ask the user a lot of questions about how to combine those duplicates and resolve conflicting information. Unless you have a huge number of duplicate contacts, a little copy and paste from one Contact item to another is probably your best choice.

Tools

1-Click Duplicate Delete

1-click solution to remove duplicate mails, contacts or calendar items. Merges contacts automatically, has an undo function and a configurable advanced mode. Version 3.03 Now supports Outlook 2010 (both 32 and 64 bit).

Contacts Scrubber

Free (up to 100 records) or Pro version (unlimited records) to clean up duplicate contacts. Lets you make field-by-field choices of which data you want to retain and drag and drop the data. Merges categories and other keywords fields. Supports custom forms. Works with Outlook 2003 to 2010. Version 4.

Written by

Diane Poremsky
A Microsoft Outlook Most Valuable Professional (MVP) since 1999, Diane is the author of several books, including Outlook 2013 Absolute Beginners Book. She also created video training CDs and online training classes for Microsoft Outlook. You can find her helping people online in Outlook Forums as well as in the Microsoft Answers and TechNet forums.

If the Post Coment button disappears, press your Tab key.