How can I merge duplicate contacts in Outlook?
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?
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.
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.
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