Desktop Mailer Export

This file is comma-delimited, with each field surrounded by quotes. The file will be written to the PW/data directory and named <productid>dd.txt, where “dd” is the day of the month.

The additional fields for single copy mail routes will only export for routes with a single copy type that matches the single copy type specified in the Business Rule— For which single copy type should mail labels print when using Postalsoft Presort and Label? These fields will not be exported if the Business Rule is not answered. If exported, the additional fields will be blank for subscriber records.

Field	Comments
Label Group ID	CAPS
Edition ID	CAPS
First Name
Last Name
Firm Name
Address Line
Unit
Extra Address Line
City
County
State	Format x(2)
Country
Zip Code
Zip Extension
Zip Bar Code	Format x(2)
PO Route Type
PO Route Walk Sequence	Format “9999999”
Lot	Format “9999”
Lot Sequence
Delivery Point Usage Code	Format x(1)
Subscriber
Subscription ID
Expire Date
Address ID
Billing Method
Additional fields for single copy routes
Route ID
Draw Total
Publication Firm Name
Publication Name
Publishing Date
Publication Address
Publication Unit
Publication Extra Line
Publication City
Publication State
Publication ZIP
Publication ZIP Extension
Publication Delivery Point Bar Code
USPS Number
Truck ID
Truck Name
Truck Drop Order
Relay Info (4 fields)	Format x(30)
Bundle Info (4 fields)	Format x(30)
Route Drop Location
Route Drop Instructions
Truck Drop Location (4 fields)	Format x(30)
Truck Drop Instructions (4 fields)	Format x(30)