Support 805.461.7300
Sales
Our Technology. Your Success.

Combine multiple people at the same address into one record

The following command will combine multiple people at the same address into one record. Instead of merging two or more people with the same name as “The Jones Family”, they will be listed by first name and separated with “and”, e.g., John and Mary Jones, and Bob Thomas vs. The Jones Family, and Bob Thomas.

Download the familyfriendsnamemergeand.zip file, then extract it into the C:\Program Files\AccuZIP6 5.0 folder.

With your database open in AccuZIP6, pull down the Edit menu to Command. Copy the command from the Code box below and paste it into the Command Statement Syntax area of the Command window:

*To format First as Uppercase, enter 1 as the parameter

=FamilyFriendsNameMergeAnd(1)

*To format using PerfectCaps, leave the parameter out or use 0

=FamilyFriendsNameMergeAnd()

This automatically creates a new database in the same folder as the original with “_new.dbf” as the ending, e.g., Demofile.dbf would result in Demofile_new.dbf.

The following field names must be present in the database:

First
Last
Address
Zip

« Back to Commands

I just wanted to take a moment and let you know what an asset Donna Tackett is to your organization. I can not tell you how many times she has helped me understand direct mail as well as the software. She has definitely become my “go to “ person when it comes to doing a mailing. Always professional and personable, I can’t brag about her enough.
B.S., Fayetteville, NC