Support 805.461.7300
Sales
Our Technology. Your Success.

Merge Data from Duplicate Records into 1 record and 1 Field

This command will combine information from up to 3 different fields and 30 duplicate records into one record.
  • Download the command file to your system.
  • Extract the “Merge Dup Information Into A Single Field 30 Max.txt” into the AccuZIP6 5.0\Commands Folder.
  • Extract the “merge_dup_any30.FXP” directly into the AccuZIP6 5.0 folder.
  • Open the database that you would like to run the command on.
  • Run the duplicate search as normal, MAKE SURE TO SELECT “Backup Duplicates” in that screen.
  • Run the command from the Edit|Command option. This command will combine up to 30 matching records into one field.
  • In the command you can combine up to 3 fields, simply list the fields in the command.
Example:
**1st Field**
COM_FIELD="FIRST"
=MERGE_DUP_ANY30()
**1st Field**

« Back to Commands

AccuZIP’s Professional Services Team has been a great resource for helping me launch Informed Delivery campaigns for my clients. I am a small direct mail marketing agency specializing in helping my clients find and retain new customers with direct mail. Informed Delivery is the best thing the post office has come up with in my 30+ years in the business. However, just like everything else with the post office, they don't make it easy. AccuZIP has made doing these digital campaigns very simple. I have analyzed campaign results and found the price per click through to the client's website less than an Adword campaign. I am looking forward to working with AccuZIP and their entire Professional Services Team with more clients and campaigns.
S.R., Raleigh, NC