MAIL: Printing Mailing Labels

MAIL lists customer names and their addresses for mailing labels.

Table Details and Type

Program Type:

Report

Page Width:

80

Lowest table:

CUSTOMER

Fast pass table:

CUSTOMER

Sequencing table: CUSTOMER

 

Report Heading

"Customer address labels".

Field Processing

Fields are normally printed across the page, like this:

          Barnes J       Townsend House
Little Downham
Pymore

In field processing, you can specify that the field is folded. This causes printing to continue at the beginning of the next line, as in:

          Barnes J (folded)
Townsend House
Little Downham
Pymore

Summary of field processing:

Nr Name          Type Occurs Sort Tot List L/Brk P/Brk Rpt Page Break Fold

1 NAME C30 Yes No No Yes No No No
in CUSTOMER
2 ADDRESS C30 Yes No No Yes No No No

Record Selection Condition

All records from the CUSTOMER table are selected.

Output Options

The standard page header that includes the date, time and page number is switched off.

Screen ?      Yes                Blank character
Printer ? No Remove trailing blanks ?
File ? Yes
Print device DEFAULT_PRINTER Ask for start/stop values ? No
File Name MAIL Pause after each page ? No
Repeat fold headers ? No Subtotal only program ? No
Print date/time/pagenr ? No Suppress 1 item totals ? No
Spacing after last fold 1 Suppress grand totals ? No
Spacing at end of page 4

Running the Report

REPPRINT -DB SALESORD -PROG MAIL