Zip Codes

Zip Code Tables

View and locate Zip Codes. Add or edit new codes.

Instructions
The Zip Code table in Mailware is periodically updated to reflect changes from the U.S. Post Office. You can view and search for Zip Codes. You can also make your own changes to the Zip Code table. Mailware uses the Zip Code table to automatically enter City and State names when you type a Zip Code on a customer account or order.

  1. To access the Zip Code  feature click on the Setup Tab on the Mailware ExplorerSetup Tab
  2. Then select the Zip & Postal Codes icon form the Mailware Explorer.Zip and Postal Codes NOTE: You can also access the sales tax screen from the Inventory option in the top navigation bar. Navigation Tool Bar
  3. This will display the Zip Codes screen. Zip Codes Screen
  4. To add a new zip code to the table click on the New Zip Code button.  This will add a new record where the cursor is located.
  5. To search for a zip code in the table click on the Search Button button.
  6. This will open the Search screen Zip Code Search
    1. The search screen automatically searches by the Zip Code key field.
    2. The search field uses Real-Time Incremental search so that when you start typing numbers in the Search Character field it will start searching from the first character.
  7. To edit existing Zip Codes tab to the code you wish to change and type the new information (Zip Code update installs are optional, but will overwrite your changes if you accept them).
  8. When you have completed updating the Zip Codes table click on the Exit Button button in the upper right corner of the Zip Code screen.  Any changes you have made will be save automatically.

Note: The Mailware Zip Code table is periodically updated. Check the downloads section of our web page for updates.

UNDER THE HOOD: The zip code table is only used when adding new orders or customers to the Mailware database.

In the Customer table, when you key in the zip code into the Zip or ShipZip fields the system does a lookup into the Zip table and if a matching record is found the system will populate the appropriate City and State fields with the data from the Zip table.

In the orders table, if you key in the Zip code into the ShipZip field the system will do a query on the Zip table and if a match is found it will populate the ShipCity and ShipState fields in the orders table.

Note: As of build 1115, the orders that are downloaded via the MCM are not checked against the Zip code table for bad values.  This is because the zip code tables in Mailware are only for the United States and Canada and are only updated when a new version is downloaded.