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 got a virus and had to have my computer practically rebuilt resulting in losing my custom settings, etc. I just finished an online remote session with Geoff. He was amazingly helpful, patient and upbeat. He spent over 1½ hours with me. Not only did he help me with what I asked him for, he gave me a lot of additional information making my mailing process easier. I've been using AccuZIP for years now and have never taken the time to commend the company for its excellent customer service. I have had good experiences with all of your techs and will absolutely recommend you to anyone I know who needs this kind of software. Thank you for such a user-friendly, customer friendly program!

S.F., Kansas City, MO