Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I wanted to improve my address book and got a Memotoo account, which takes in contact info from LinkedIn, Facebook, Twitter, Gmail, Android and Outlook (and several others).

You can imagine that I have the same contacts on different platforms and I was assuming when I started syncing, it would pick up similarities and merge these several sources to get one better version.

However, because I hadn't noticed it was both way syncing, I ended up with 2000(!) contacts on my phone, Outlook and Gmail! So now I need to clean up the mess and Memotoo isn't really capable of merging this many contacts automatically, so I'm looking for an easier way to do this through Outlook 2010.

Are there any options for merging my duplicate contacts?

share|improve this question
add comment

5 Answers 5

up vote 6 down vote accepted

There is MAPILab Duplicates Remover for Outlook, which is not free, but not expensive. I've not used it, but i think the free trial version will only work for 10 contacts at a time, if it is anything like..

...Duplicate Email Remover from MAPILab, which I have used, and which worked very well.

EDIT: Having looked a bit closer at that add-on, it seems that you can choose which fields it uses to detect duplicates, but all you can do is flag or delete them, and not merge them.

The best thing I can think of is for you to export all your contacts into Excel through a CSV file, where you can manipulate them so that fields are copied across the different entries, and then delete the dupes. It will take some time and effort, but at least it will be easier on a spreadsheet.

share|improve this answer
    
+1 for doing it 'the easy manual way' with Excel at least editing is easier there –  Ivo Flipse Nov 17 '10 at 8:05
add comment

For Outlook 2010.

  • Change your contact view to List Mode.
  • When on one of the duplicates hit Ctrl-C.
  • Then go to its duplicate partner. Hit Ctrl-V – it'll show a pop up asking you if you want to update this contact with the other info.
  • Then go to the first one and hit Del to delete it.

This method does not merge the Notes field though.

share|improve this answer
add comment

You can try out Scrubly which is a service that helps you manage your contacts.

Scrubly`s features:

  • Remove duplicate contacts
  • Easily merge and resolve conflicts
  • Eliminate duplicates across folders
  • Powerful algorithm for safe, quick and thorough scans
  • Automatically backs up your address book. Safe storage you can access and download any timein the future
  • Safely revert your data back to its original condition at any point in the process. You have complete control
share|improve this answer
add comment

What I ended up doing was create a new contacts folder. Copy and paste your entire contacts list to this folder. Then simply select all of the contacts in the new folder and paste them back to the original contacts folder.

As they are copied you will be asked to Crete duplicates or update existing contacts. Choose to update existing. I have over 1000 contacts and this process worked for all but a few contacts.

share|improve this answer
    
That's actually quite inventive, thanks for the suggestion –  Ivo Flipse Nov 17 '11 at 20:02
    
Seems to work for me. Now I just have to figure out how to delete the old duplicates, but that's not as difficult. –  SilverbackNet Jul 11 '12 at 23:30
    
After merging, the further action of exporting everything, deleting, and reimporting them with delete duplicates selected cleaned everything right up. Thank you! –  SilverbackNet Jul 11 '12 at 23:40
add comment

Check out this official support document: http://support.microsoft.com/kb/299349

This procedure changed with the 2010 version, so make sure to look at the second set of instructions. This can be applied to many elements of outlook, so you can just limit it to contacts.

Outlook 2010

  1. In Outlook 2010, select the folder for which you want to delete duplicate items.
  2. Click the View tab in the Ribbon, click Change View in the Ribbon, and then click to change the folder view to a table type view. For example, click the List icon.
  3. Right-click a column heading, and then click Field Chooser.
  4. From the list at the top of the Field Chooser, click to select the All fields .
  5. Drag the Modified field to the table heading.
  6. Verify that the duplicate items have a unique date from the original set of items. If it is unique, click the Modified heading so that the items are sorted by this field.
  7. Click the first item in the set that you want to delete, scroll to the last item in the set that you want to delete, and then click the last item while you hold down the SHIFT key.
  8. Press DELETE to permanently delete all selected items.

Did you attempt anything yet?

share|improve this answer
    
I managed to get the modified field, but don't really understand what they mean with a unique data. Also the field stays empty, so I don't really understand how to use it. The list view is helpful though, because it let's me edit inline! –  Ivo Flipse Nov 17 '10 at 8:04
1  
-1 this isn't a mechanism to merge contacts –  cori Mar 10 '11 at 13:58
    
This #1 does not work. When I click the top of the Field Chooser there is no "All Fields" option and as I read through, the directions do not explain how to merge contacts anyway. This was useless. –  user101517 Oct 14 '11 at 22:12
    
I think this is a method for removing duplicate contacts - ie you accidentally selected all your contacts and copied them into the same folder, creating two of everything. It won't remove duplicates of individual contacts. –  SqlRyan Sep 6 '12 at 20:36
add comment

protected by Community Mar 20 '12 at 11:36

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.