How to merge duplicate contacts in Outlook?
When we copy/move contacts from one folder to another in Outlook, duplicate contacts will very likely come out. Removing the duplicate contacts may not be the better way, because one contact may contain fields that the other duplicate one leaving as blank. As a result, some user think of merging duplicates. In this article, I will show you how to merge duplicate contacts in Outlook.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013 and 2016.
Let’s say you will move all contacts from A folder to B folder in Outlook. To merge duplicate contacts during moving, you can do as following.
Step 1: Click the File > Options.
Step 2: In the Outlook Options dialog box, click the People (or Contacts) in the left bar, then check the option of Check for duplicates when saving new contacts in the Names and filling section.
Step 3: Click the OK button to close the Outlook Options dialog box.
Step 4: Shift to the People view (or Contacts) view, open the A folder in the Navigation Pane, select one contact in the folder, and then select all contacts with clicking the Ctrl + A keys in a meanwhile.
Step 5: Right click the selected contacts, and then click the Move > B folder from the right-clicking menu. See screen shot below:
Note: If the destination folder is not listing in the right-clicking menu, just click the Move > Other Folder from the right-clicking menu, and then specify the destination folder and click OK button in the Move Items dialog box.
Step 6: If duplicate contacts exist, it will pop up the Duplicate Contact Detected dialog box. Just click the Update All button.
Then all contacts in A folder were moved to the B folder with all duplicate contacts merged.
In Outlook 2007, if you want to merge duplicate contacts when moving from one folder to the other, you also need to enable the option of Check for duplicate contacts.
Step 1: Click the Tools > Options.
Step 2: In the opening Options dialog box, click the Contact Options button.
Step 3: In the new Contact Options dialog box, check the option of Check for duplicate contacts in the Name and filing options for new contacts section.
Step 4: Click two OK buttons to close both dialog boxes.
Then you can follow the same steps as we introduced in the Outlook 2010 and 2013 to merge duplicate contacts when moving from one folder to another.
To easily merge all duplicate contacts in specified contacts folder in Outlook, here I recommend you to use the Merge Duplicate Contacts utility of Kutools for Outlook. Please do as follows.
1. Click Kutools > Duplicate Contacts to activate the feature. See screenshot:
2. In the Duplicate Contacts dialog box, you need to:
2.1 Specify the contact fields you will merge the duplicates based on in the Please select the criteria for checking the duplicate box;
2.2 Select a contacts folder or multiple contacts folders you will merge duplicates inside in the Please select a data source file box;
2.3 Select Merge duplicate contacts from the Select how duplicate contacts are processed drop-down list.
2.4 Click the OK button.
3. Then a Kutools for Outlook dialog box pops up. if you want to back up the contacts before merging, please click the Yes button, otherwise, click the No button. See screenshot:
If you choose to back up the contacts, then a Browse For Folder dialog box will open. You need to specify a folder to save the backup contacts, and then click the OK button.
4. Then all duplicate contacts are merged successfully by certain contacts fields in specified contacts folder(s). Please click the OK button in the Kutools for Outlook dialog box. And finally, close the Duplicate Contacts window. See screenshot:
Note: You can preview results of all deleted and merged contacts in the Duplicate Contacts window after finishing the duplication merging as above screenshot showed.
Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 60 days. Download the free trial now!
20+ Powerful Tools and Features for Outlook 2010 / 2013 / 2016 / Office 365:
Compatible with Outlook 2010 / 2013 / 2016 / Office 365 (32/64);
Compatible with Windows XP, Windows Vista, Windows 7 / 8 / 10, Windows Server 2003/2008, Citrix System and Windows Terminal (Remote Desktop) Server;
Free trial without feature limitation in 45 days!
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 4 months agoI started with 4 contact records for the same contact. Following these instructions I now have 11. This does not work! DO NOT USE THIS
To post as a guest, your comment is unpublished.· 1 years agoHave to move to folder, then back again. Merge popup initiates on the second move.
To post as a guest, your comment is unpublished.