We help IT Professionals succeed at work.

Merge many contacts in Outlook

PCLANTECHS
PCLANTECHS asked
on
302 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.
Comment
Watch Question

Thomas GrassiSystems Administrator

Commented:
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.

Author

Commented:
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?
Thomas GrassiSystems Administrator

Commented:
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.
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
No other valuable solutions were provided that we followed.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.