Export customer account numbers, names, and billing-address lines for a selected rate. The output is a tab-delimited text file that can be opened in a spreadsheet or used for address processing.
Using this option
- Choose Print > Customer Listings > Export Billing Addresses by Rate Code.
- Select Rate to Export. Leave it blank only if you intend to include all rates.
- Select include Final Billed if final-billed customers should be included; otherwise only customers not marked final billed are exported.
- Choose Filename and continue. The default is a desktop text file, and [Rate Code] in the filename is replaced with the selected rate code.
- Use the completion message to locate the file and review the Account, Name, and Billing Address 1 through 4 columns.
Notes
An existing output file is replaced. Choose a new filename if you need to retain an earlier export.
This option exports the billing-address fields; it does not change customer records. When opening the text file in a spreadsheet, import account numbers as text so their formatting is preserved.