merging duplicate files

Status
Not open for further replies.

christian09

Member
Outlook version
Email Account
IMAP
Ok, I have about 1000 contacts. I have duplicates of each, b/c the first had incorrect phone numbers, so I exported to csv and put the right ones in, I then imported back into outlook, but kept the duplicates. Why did I do this? The first set of "wrong number contacts" each had tasks assigned to each contact. Now, I am trying to find a way to merge the 2nd into the first so the correct phone number is there AND the tasks remain assigned. thank you
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Contacts scrubber will do this easily - http://www.teamscope.com/otherpro/utilities.asp - the free version is limited to 100 though.




You could try moving the imported contacts to a new folder then move them back a few at a time and let outlook merge the contacts. In theory it works - but test it to be sure it keeps the correct contact.
 

christian09

Member
Outlook version
Email Account
IMAP
Thank you,

I tried this, but here is my main issue. If I have 1 contact that says Mary Smith with incorrect phone.(This contact has a task assigned to it, which I definitely want to keep this way) the duplicate contact has Mary Smith and the correct phone num., but does not have the task assigned to it. So I want to move the correct phone into the 1st contact so I can keep the task assignment. I may be misinterpreting the teamscope software, but I didn't see an area where I can just move the correct phone into the 1st contact.

Here is a solution that may work, but since I have trouble undoing things in outlook, I will run it by you 1st. What if i export all contacts(including duplicates) to .csv. I Just delete all contacts within outlook. Then I fix it in excel(I know which of the 2 contacts has the assigned task), then import it back into outlook. The only worry I have is will the task assignment stay with its contact thru import/export?

Thank you.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
exporting will break the task links. (well, importing will)




the last time i used scubber (3 or so yrs ago) it did exectly what you want. I don't know if it has changed - will check it out.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Article on merging pst file Using Outlook 1
Diane Poremsky Merging Two Calendar Folders Using Outlook 0
C Merging Word and Access into Outlook Using Outlook 4
M mail merging contacts and contact groups. can code achieve this? Using Outlook 11
C Managing & Merging .pst files Using Outlook 3
H outlook email merging with attachments Using Outlook 4
T Merging multiple Business Contact Manager files BCM (Business Contact Manager) 0
S Merging From Outlook 2003 Using Form or Folder Level Fields Outlook VBA and Custom Forms 9
Rupert Dragwater Duplicate email in Folder Using Outlook 7
L Duplicate calendar entries in Outlook 365 Using Outlook 3
J Recommendations for Outlook Duplicate Email Remover Using Outlook 6
D Duplicate Emails on Phone and Tablet Using Outlook 0
I Google Calendar <calendar-notification@google.com> appearing as a duplicate entry Using Outlook 2
O Delete duplicate emails - subscription notifications Using Outlook 5
T Deleting duplicate emails Using Outlook 2
S Receiving duplicate messages from RSS feeds Using Outlook 3
M Duplicate Primary Mail Accounts outlook 2010 Using Outlook 0
C Auto categorize duplicate subjects Outlook VBA and Custom Forms 11
K Outlook 2010 duplicate download emails 1 inbox 1 PST no updates Using Outlook 3
C Don't forward duplicate Using Outlook 0
E Duplicate, nested account folders on ATT server Using Outlook 10
S Duplicate emails Using Outlook 2
O Remove duplicate mail items Outlook VBA and Custom Forms 6
F Avoid sending duplicate using Outlook script Outlook VBA and Custom Forms 2
O How to delete duplicate RSS messages? Using Outlook 6
MattC Problem with Outlook 2007 & iCloud / duplicate tasks Using Outlook 1
Horsepower Duplicate RSS feeds Using Outlook 5
M How to duplicate content of one field in another field? Outlook VBA and Custom Forms 3
P Duplicate Standard Views Using Outlook 3
J Duplicate contacts Using Outlook 1
T Duplicate emails in different "sent" boxes. Using Outlook 2
N Deleting Duplicate Calendar Entires Outlook VBA and Custom Forms 2
J Duplicate Reminders Using Outlook 5
J Duplicate Attachments in Content.Outlook Using Outlook 4
J Duplicate emails on some computers, but not on others Using Outlook 1
M best duplicate contact remover? Using Outlook 6
Mr Mayor Duplicate Task LIST, not "duplicate tasks".... Using Outlook 10
V Duplicate and triplicate messages in Inbox Outlook 2013 Using Outlook 20
M How to remove duplicate history items BCM (Business Contact Manager) 7
D Isn't there an easy way to remove duplicate contacts in outlook? Using Outlook 1
H Duplicate E-mails and Wetransfer Using Outlook 4
J Duplicate email when receiving email sent To: me and CC to a group I belong to Using Outlook 16
O Duplicate folders in Outlook 2003 Using Outlook 3
C duplicate e-mails from gmail? Using Outlook 1
T Outlook 2013 Duplicate Recipients Using Outlook 9
wisedave Duplicate Emails Downloading Everytime I Open Outlook Using Outlook 1
C Duplicate emails from pop but only for certain date range? Using Outlook 4
S Duplicate Read Receipt Using Outlook 4
S can't delete duplicate account under Outlook 2007 (Win 7) Using Outlook 16
I Duplicate contacts in iPhone resulting from LinkedIn connector in Exchange Using Outlook 3

Similar threads

Top