Support 805.461.7300
Our Technology. Your Success.

Combine multiple records into one record that have the same last name at the same address

Example Input:
John Smith 100 Main St
Jane Smith 100 Main St
Kevin Smith 100 Main St
Result you will see in the field named FIRST:
The Smith Family

Make sure the name information is separated into the First and Last fields. if not you can Parse the name information from the Special>Parse> Name option.
Run the duplicate search from the Select>Show Duplicates option, with Household selected in the general tab as the search criteria.
IMPORTANT: Make sure to select the "Backup Duplicates option" at the bottom of the screen.
Update the database with the duplicate results.
Run the following command from the Command window (Edit>Command) You can copy/paste the following command into the Command statement Syntax area of the command window and click RUN.

ON ERROR com_message=message() 
PUBLIC cDupFilePath,comAlias,comUnique 
PUBLIC ARRAY comArFiles(1,1) 
* Get the current Databases Alias Name 
* Capture all back file names in memory 
* Create the variable name for the duplicate records 
USE (cDupFilePath) IN 0 ALIAS (comUnique) 
INDEX ON therec_xx tag therec_xx 
ALTER TABLE (comAlias) ADD COLUMN priority C(1) 
ALTER TABLE (comAlias) ADD COLUMN name2 C(60) 
replace name2 with first for "1"$(priority)
replace all priority with "" 
REPLACE priority WITH IIF(!DELETED(),'1','2') for SEEK(RECNO(),comUnique) 
replace first with "The "+allt(last)+" Family", last with "" for "1"$(priority)
delete for "2"$(priority)
USE IN IIF(USED(comUnique),SELECT(comUnique),0) 
RENAME (FORCEEXT(cDupFilePath,"rpt")) ; 
   TO (cDupFilePath+".txt")

« Back to Commands

I have been a loyal customer for 14 years and love your products. During my career as a mailing professional, I have experienced that the mailing industry is in a constant state of change: through technology, equipment, software, postal regulations and automation requirements. During this time, I have always been able to trust and depend on Accuzip software. It is evident Accuzip is always at the forefront of these changes. When our team is having difficulty with a mailing, we know that we can rely on Accuzip tech support to resolve any issue. We have always received excellent customer service. Accuzip software, support and expertise has helped me to develop a professional mailing operation at our University and I could not have done this without you. Your software makes my job successful and less stressful. Thank you!
D.H., Forest Grove, OR