Support 805.461.7300
Sales
Our Technology. Your Success.

Create a new database for every Unique State in the database

This command will identify each unique state in your address list and create one new file for each state represented.
For example, if you have 50 records in Alaska and 100 records in Hawaii, this command will create an Alaska database with your database's 50 Alaska records and a separate Hawaii database with the 100 records from your database that were in the state of Hawaii.

1. Download and extract the unique_st.zip file to the C:\Program Files (x86)\AccuZIP6 5.0 folder.
2. Create a command from the Edit>Command window. Type the following into the Command Statement Syntax area:

 
DO UNIQUE_ST

3. The command will create a directory named “C:\ST files” and populate with separate dbf’s for each state in the database.

« 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