Add a package break mark to non-packaged based presort file

Presort your list as normal.

Click the Print Labels option in the Print Presort screen.

Select Disk File for the Output format.

Select ALL fields, and export to an AccuZIP6 5x database.

Open the Edit|Command window and paste the following:

ON ERROR com_message=message() comAlias=ALIAS() SET SAFETY OFF SELECT GPB_ID,cont_id FROM (comAlias) GROUP BY 1,2 INTO TABLE "C:\unique.dbf" readwrite USE USE ("C:\unique.dbf") IN 0 ALIAS "unique" SELECT(comAlias) INDEX ON allt(cont_id)+allt(GPB_ID) tag mytag SELECT ("unique") alter table alias() add column sequence c(7) replace sequence with &comAlias..sequence for SEEK(allt(cont_id)+allt(GPB_ID),comAlias) SELECT ("unique") INDEX ON allt(sequence)+allt(GPB_ID) tag mytag SELECT(comAlias) replace Pkgmark_ with "*" for SEEK(allt(sequence)+allt(GPB_ID) ,"unique") USE IN IIF(USED("unique"),SELECT("unique"),0)

ON ERROR com_message=message()
comAlias=ALIAS()
SET SAFETY OFF
SELECT GPB_ID,cont_id FROM (comAlias) GROUP BY 1,2 INTO TABLE "C:\unique.dbf" readwrite
USE
USE ("C:\unique.dbf") IN 0 ALIAS "unique"
SELECT(comAlias)
	INDEX ON allt(cont_id)+allt(GPB_ID) tag mytag
SELECT ("unique")
	alter table alias() add column sequence c(7)
	replace sequence with &comAlias..sequence for SEEK(allt(cont_id)+allt(GPB_ID),comAlias)
SELECT ("unique")
	INDEX ON allt(sequence)+allt(GPB_ID) tag mytag
SELECT(comAlias)
	replace Pkgmark_ with "*" for SEEK(allt(sequence)+allt(GPB_ID)  ,"unique")
USE IN IIF(USED("unique"),SELECT("unique"),0)

This will add the * in the Pkgmark_ field for package breaks on non-packaged-based mailings.

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

I Just wanted to let you know we are in the Postal Fort Worth Texas Division and I received a call from someone in their office today wanting to ask me some questions. He asked if I understood about the changes with the move update starting for this month, then he asked me what software we were using. I explained to him that we have been using AccuZIP Software for the last 20 years and I thought you were the #1 in the United States. I told him that you were the only software displayed in the Postal Section of the Smithsonian Institute. He asked me if I had to manually change the updated addresses and I told him no that the Software did it for us and I could print a report showing the old address and the new address. He told me out of 32,000 names that were updated only 3 were wrong and he just wanted to call me to see what Software we were using. Thanks for such good software and support from your company over the past 20 years.

C.K., Wichita Falls, TX