Removing Duplic Contact Entries

[Tom]

May have your suggestion for an application that will help rid my Outlook
2003 of duplicate Contact entries? I would be especially grateful for an
application that that also identifies NEAR duplicate entries, as I have a
number of duplicates that differ only by a single rather innocuous entry in
the Notes for the contact.

Thanks in advance for your prompt replies.

 

[Harvey Yancey [MSFT]]

Hi Tom,

What I have done in the past is export the contacts to a CSV file, import
into Excel, sort by the suspect
duplicate field ... then delete the dups (you can write a fairly simple VBA
macro to do this if you want to automate it).

Once you have finished in Excel save to a CSV file, delete all of your
current contacts in Outlook then import the CSV.

HTH

Regards,

Harvey Yancey [MSFT]
Exchange Client/Server Infrastructure
(e-mail address removed)

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Tom]

You make it sound so easy, but considering that I've never used Excel, would
you be able to recommend an "idiot proof" third party product?

Another thing. Finding the "suspect subplicate" is part the problem. All I
know from Coutlook is that I havee hundreds of NEAR duplicates. What makes
them near duplicates is that the address info is normally identical. What
varies is a few innocuous entries in the notes.

Hi Tom,

What I have done in the past is export the contacts to a CSV file,

import into Excel, sort by the suspect duplicate field ... then delete

the dups (you can write a fairly simple
VBA

macro to do this if you want to automate it).

Once you have finished in Excel save to a CSV file, delete all of your

current contacts in Outlook then import the CSV.

HTH

Regards,

Harvey Yancey [MSFT]

Exchange Client/Server Infrastructure


This posting is provided "AS IS" with no warranties, and confers no
rights.




Outlook

an

a