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

AccuZIP's customer service is great. It keeps us from having down time and I'm always able to get a quick answer. don't have to worry about the size of the order I'm working with a client on. Most times, AccuZIP employees know more than the USPS employees. I've been able to navigate the lack of government employee training, which saves time, money and headaches.
M.L., Lansing, WV