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 was looking for an easy to use all-in-one postal software solution and was working with Satori Software. They quoted me $10,000.00 which was out of the realm of our budget. I was also lead to believe that they were the only solution, until I found Accuzip. I was able to save my company over $9,000.00 with one phone call to your courteous and knowledgeable sales staff. Your product does everything that we need and much much more. Thank you Accuzip!

J.S., Newark, OH