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 share how FABULOUS [Geoff] is and you should keep him for sure! I have had the best service and training from him in the last few days that it has sold me on keeping AccuZIP @ my new job. I was new to this software and learning in “trial by fire” mode and he got me thru it without any burns! He is amazing and deserves a raise, bonus, employee of year- SOMETHING BIG. I have dealt with the mail industry for about 30 years and never received this level of support and so positive. I am forever grateful and will suggest him and this product if asked. I am being very serious about his knowledge, skill, and interpersonal skill(hard to find these days).

K.P., Colorado Springs, CO