Support 805.461.7300
Our Technology. Your Success.
Tech Notes

Exporting your data in presort order

To export your data in presort order, follow the instructions below.

  1. Presort your database in AccuZIP6.
  2. From the Print Presort window, click on the Print Labels button.
  3. In the Print Settings window, choose Diskfile from the Output pull down menu.
  4. Click Continue.
  5. In the Export Setup window, select the fields you want to export, or check the Export All Fields box.

NOTE: When selecting the Endorse field, if you want to add the container number, bundle number, and asterisks to the endorsement line when you export it, then add this expression to the expression text box on the endorse row:

ALLT(PADL(TRANSFORM(VAL(cont_id)),3," "))+"*"+ALLT(PADL(TRANSFORM(VAL(gpb_id)),3," "))+"*"+ALLT(PADL(TRANSFORM(VAL(sequence)),7," "))+PADL(ALLT(Endorse),30,"*")
  1. Select your Export Format from the Export Format pull down menu.
  2. Click Export.
  3. Give the File a name and choose a location to save the file.
  4. Click Save.

A new file has been created. This file is in presort order, and can be used in a mail merge situation.

NOTE: If you are exporting for a Mail Merge and intending to print the delivery point barcode, assign the USPS Barcode font, size 15, to the barcode field in MS Word. If you're exporting the IMBARCODE field to print the intelligent mail barcode, use the USPS4CB font, size 16.

« Back to Tech Notes

You Know, When God created the Seven Wonders of the world, He created another one called AccuZIP!! Thank You for all your help!
R.B., Omaha, NE