Support 805.461.7300
Sales
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,"*")
Select your Export Format from the Export Format pull down menu.
  1. Click Export.
  2. Give the File a name and choose a location to save the file.
  3. 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

"I recently ended probably the most helpful chat ever with your employee Aurora Crouch! She was so extremely thorough and made sure that the install and setup of Accuzip was ready to go. She was also so patient and polite as I fumbled around trying to remember how a PC works! I honestly can't say enough about how amazing and helpful and kind she was! I appreciate her help so very much, she is a great employee and makes it so easy for people like me (who have no idea what they are doing) to get things set up as they need to be. Thank you so much for all of your help and for having someone like Aurora on staff, she is literally a godsend!"
C.C., Savannah, GA