[Last Call] Learn how to a build a cloud-first strategyRegister Now


Trying to merge Outlook 2010 Contacts

Posted on 2011-10-22
Medium Priority
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
  • 2
LVL 99

Assisted Solution

by:John Hurst
John Hurst earned 1000 total points
ID: 37012590
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

wolfcamel earned 1000 total points
ID: 37012664
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

Author Comment

ID: 37025641
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 99

Expert Comment

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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
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…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

830 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