Solved

Merge many contacts in Outlook

Posted on 2013-11-27
5
237 Views
Last Modified: 2013-12-16
We just migrated new customers over to Office 365, which caused all of their contacts to duplicate. Some of these duplicates have additional information in them, which means we want to merge contact records. We have over 500 contact entries to go through. Not all of them are duplicated, but that is a very large amount to go through manually and see what information needs merged.

Example:
Contact record 1:
User Tom
123-456-7890 Office
user@myemail.com

Contact record 2:
User Tom
423-789-5460 Mobile
user@myemail.com


Contact record 1 has more information in it than contact record 2, so we want to merge these duplicate contacts into 1, and all of the information be there.

I am currently running the free trial of Scrubbly.com, but want to see if there are others available as well.
0
Comment
Question by:PCLANTECHS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 39681543
We just went thru something similar.

We exported the contacts into a csv comma delimited file

Used excel to sort them and with several filters we got all contacts grouped together.

Made it very simple to delete duplicates

We copy and pasted many entries with additional information etc.

Worked very nice.
0
 
LVL 1

Author Comment

by:PCLANTECHS
ID: 39681595
So you manually went through all duplicate records and copied the information from contact 2 to contact 1 (as in my example above) to "merge" the contact records?
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 39681879
YEs the excel spreadsheet works great.

then after your done you can import them back into outlook.

It is tidiest work but well worth it.
0
 
LVL 1

Accepted Solution

by:
PCLANTECHS earned 0 total points
ID: 39712604
We decided to use the product Scrubly due to the sheer number of contacts (over 1,000).
0
 
LVL 1

Author Closing Comment

by:PCLANTECHS
ID: 39721058
No other valuable solutions were provided that we followed.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question