Adding County Information to Simplified Lists

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
Terry
Site Admin
Posts: 1983
Joined: Wed Sep 20, 2006 3:45 pm

Adding County Information to Simplified Lists

Post by Terry » Thu Aug 14, 2014 10:24 am

If you are creating an EDDM/Simplified Mailing List and you want to claim In-County Rates, those records have to include the county information in it. Considering you can't validate a record with no address, you can use this command to create and populate the Countynm_ and countyno_ fields, and then choose In-County Rates on the presort setup window to get your in-county rates claimed.

Code: Select all

ON ERROR com_message=message()
SET SAFETY OFF
ALTER TABLE (alias()) ADD COLUMN countynm_ C(30)
ALTER TABLE (alias()) ADD COLUMN countyno_ C(3)
USE (ADDBS(xDefFldr)+"DMM\_uszips.dbf") IN 0 ALIAS _uszips ORDER USZIP
REPLACE countynm_ WITH _uszips.countynm FOR SEEK(LEFT(zip,5),"_uszips")
REPLACE countyno_ WITH _uszips.countyno FOR SEEK(LEFT(zip,5),"_uszips")
USE IN (SELECT("_uszips"))

Post Reply