# 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)     |