Trying to merge Outlook 2010 Contacts

Posted on 2011-10-22
Last Modified: 2012-05-12
I do not have duplicates, rather two contacts with same name and then only an email, then others with only their phone numbers.  It started when I imported contacts from a phone that had the names of my contacts and just their numbers.  Later on I imported my contacts from hotmail, which has many of the same people, but now only their emails.  

In contact I now have them as two separate contacts.  All the applications I have look like they just delete one or the other contact, but I don't want that.  I want to merge the ones with same names together to make just one contact with both in formation.  Does anyone know how to do this?  I have give or take 120 ish contacts that are like this and would rather not do them manually.
Question by:tsaico
    LVL 89

    Assisted Solution

    by:John Hurst
    Outlook sees them as totally different (even if they look similar to the human eye). So given they are different, I do not think there is any way to merge these. At least, I do not know of one. I have never don 120, but when I have this situation, I pull both up and use copy and paste and am done quite quickly.   .... Thinkpads_User
    LVL 20

    Accepted Solution

    you may be able to export them to a spreadsheet
    sort them by name
    and it then may be quicker to move the email address from one cell to the cell above - or make a macro to do this.
    and then sort again to put all the empty contact together to delete them
    and then import the spreadsheet back into an empty outlook
    LVL 9

    Author Comment

    Yeah, part of the problem is I have a few that were not in both, so when I wrote a formula to merge them, I had to remove the ones that did not need any massaging.  In any case, manual was the way to do it, and I did mine by excel.  I corrected any of the names first, to make sure they were the same, then once that was done, moved my non-duped contacts to another workbook, sorted the originals with the dupes by name, then by email, then copied the populated to the blank one above it using a formula and autofill.  Once that was done, I had every other one with complete data. filtered for duplicates on the name column, copied results to a new CSV and then deleted all my old contacts and then imported new list back in.

    What a pain, you would figure there is a way to trigger the auto compare option like when you are saving new contacts from scratch.  it compares the names to already known ones, offers to update the contact, or make new.  While not ideal either, it should at least be an option...  in any case thanks all for the suggestions.
    LVL 89

    Expert Comment

    by:John Hurst
    Thanks.  I was happy to help even though the solutions are not ideal to your case. .... Thinkpads_User

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    My experience with Windows 10 over a one year period and suggestions for smooth operation
    Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now