Monday, July 12, 2010

Remove Duplicate Contacts in Microsoft Outlook 2003, 2007, 2010

Here is what Microsoft suggests

http://office.microsoft.com/en-us/outlook/HP100985411033.aspx#2

But if someone has thousands of contacts then it will take care ages to to click on each duplicate and select, one might need to get a physio session to recover from those clicks. I had around 5oo duplicate entries in my contacts in Outlook because I was testing ActiveSync on an Exchange Server with my mailbox and the client I used had some default settings that duplicated all contacts.

Anyways I could recover my contact list in a minute but I thought this exercise might be helpful to someone out there.

Export your contacts to a CSV file

Import it and while importing contacts chose the following option “Do not import duplicate items

image

Click on next and then finish, all duplicates should be eliminated.

1 comment:

  1. This post is really great..Another alternative I discovered is the so called Scrubly duplicate remover. The nice thing about this service is that it gives you the option of viewing the contacts to be merged in advance and picking and choosing the info you want to merge so you have complete control over the merged data. It also keeps a backup of your contacts.
    Scrubly also supports Outlook, Mac Address Book and Google Apps contacts.

    Scrubly http://www.scrubly.com

    ReplyDelete

Leave a comment if you find this post useful or if you have any questions