Merge Fields from Duplicate Records Into One

If you have duplicate records in a file that you wish to merge together into a single record, this command and process will do that. This command has a limitation of 5 duplicates per entry, however.

For example, if you had a records in your database where the primary information matched, but there were accounts or other columns that might have different values, this command will create a single record with multiple account fields (account, account1, account2, etc) with each of the values in them.

First, download the file linked below:
https://www.accuzip.com/files/forum/mergedupeinfo.zip

Download the file linked above to your system.
Extract the “merge_dup_any.FXP” to the “C:\Program Files (x86)\AccuZIP6 5.0” folder.
Extract the “Merge Dupe Info Mail-it Plus.txt” to the “C:\Program Files (x86)\AccuZIP6 5.0\Commands” folder.
Open the database that you would like to run the command on.
Run the duplicate search based on how you would like to compare the records,( e.g: Person, Address or household)

Note: MAKE SURE TO HAVE BACKUP DUPLICATES SELETED

Update the database with the duplicates.
Run the command. Currently, the command is set to merge 3 fields. You can remove any of the lines or add to them if you need additional fields merged.

When the command is complete, you will see the additional fields at the end of the record with the merged data in them.

The records will be left “Flagged for deletion” in the original database. If you would like to permanently remove them you can “Pack” the database.

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

I am especially motivated to take time to draw attention to Vince. In two instances, we potentially faced loss of product – significant loss, but thanks to everyone’s efforts, most notably Vince’s, we ended up with minor re-work and zero loss of stock. He’s patient and thorough, knowledgeable and resourceful. And he’s patient – A Big Plus when dealing with me. Long story short, the guy was able to not only produce a solution, but to prove to me the veracity of it. I hung up the phone saving thousands of dollars in catalog stock, not lost but salvaged, and my department had to spend just a wee bit of time on job re-work (which I was happy to do, all things considered). But I also hung up with a peculiar urge to write about Vince, incongruent as that may be since I rarely am moved to write letters of this sort. So… In a time of crisis, Vince was a terrific asset and ally. If I were his boss, I’d attempt a merit raise authorization, he was that exceptional.

H.D., Shawnee Mission, KS