Support 805.461.7300
Sales
Our Technology. Your Success.

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)

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

« Back to Commands

I understand why the USPS needs to change things over time, but since they don't have to deal with customers' software they often don't care about the downstream effects. You guys do a great job on both fronts.
J.P., Greenville, NC