08-29-2014 07:00 AM
Act Premium 2013.Have about 10.000 ((out of 50.000 list)) of duplicates and I am trying (to avoid manually deleting) to only delete those
(on basis of Company,Contact in the three ScanDuplicate option) to keep the addresses where the fields Email,Phone,FaxPhone
are NOT empty.
Johson Company,Barbara Higgs, 12345 email@example.com
Johson Company,Barbara Higgs
So I like to maintain the first one and delete the second one. if possible automatically.
How to do this ?
08-29-2014 07:17 AM
If you could find a common element amoung the records you want to delete. Sort the lookup basised on that value. Select the contacts you want to delete, and delete them as a group.
If you have more than one element you want to sort by, select and right click to lookup selected contacts until you narrow the list down.