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

You are a genius and I have no excuse for not thinking of this before calling. Our customer is good with cutting the tops and bottoms for the booklets to get under 16 ounces. Thank you for getting me out of a jam and thank you even more for offering your help with this project! I decided to switch to AccuZIP after speaking with Steve at the Minuteman Show. I was impressed with his idea of customer service and you have totally proven him right.
M.M., Petaluma, CA