Add records and split names based on first

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Site Admin
Posts: 620
Joined: Wed Sep 20, 2006 3:20 pm

Add records and split names based on first

Post by Dave » Thu Mar 19, 2009 7:06 am

This command will duplicate a record and split the name information into the added records, when you have multiple names separated by a comma in the field named "FIRST"



First Address
John Smith, Cathy Smith, Joe Smith, Jerry Jones, Sam Reed, Jennifer Howard 100 Main ST


First Address
John Smith 100 Main ST
Cathy Smith 100 Main ST
Joe Smith 100 Main ST
Jerry Jones 100 Main ST
Sam Reed 100 Main ST
Jennifer Howard 100 Main ST

1. Download and extract the file to the C:\Program Files\AccuZIP6 5.0 folder.
2. Move the “Add Record Based On Names In First.txt” to the C:\Program Files\AccuZIP6 5.0\Commands folder. (Leave the other 2 .FXP files in the root level of AccuZIP6 5.0)
3. Open the database containing the names with commas in the field named FIRST.
4. Pull down Edit>Commands in AccuZIP6.
5. Click RUN.
6. The command will add additional records with the same address and split the names into those addresses up to 10 names.

Post Reply