Printing Multicolumn Reports as Mailing Labels

Access lets you print multicolumn reports. You can create a single-column report with the Report Wizard, for example, and then arrange the report to print values from the Detail section in a specified number of columns across the page. The most common application of multicolumn reports is the creation of mailing labels.

Creating a Mailing Label with the Label Wizard

You can create mailing lists with the Label Wizard, or you can start with a blank form. The Label Wizard’s advantage is that it includes the dimensions of virtually every kind of adhesive label for dot-matrix or laser printers made by the Avery Commercial Products division and several other North American and overseas manufacturers. You select the product number of the label that you plan to use, and Access determines the number of columns, rows per page, and margins for the report’s Detail section. You also can customize the Label Wizard for labels with unusual sizes or those produced by manufacturers who aren’t included in the Wizard’s repertoire. Several other manufacturers include a note that indicates the corresponding Avery label number.