About creating and customizing mailing labels

Microsoft Office Access 2003

Show All Show All

About creating and customizing mailing labels

Mailing labels are a special type of Microsoft Access report. You bind the labels to a table or a query, and Access generates a label for each record in the underlying record source.

The Customer Labels report in the Northwind sample database shows three-across mailing labels. To view this report, open the Northwind database in the Samples subfolder of your Microsoft Office folder, and then open the Customer Labels report in Design view.

Creating mailing labels

You can create labels either by using the Label Wizard or in Design view. The wizard asks you detailed questions about the record source, fields, layout, and format you want and creates the labels based on your answers. The wizard also customizes the page setup options for printing the labels.

Although you can manually create the labels in Design view, setting the page setup options could be a lengthy procedure. It might be faster to use the wizard to create the labels and customize the visual appearance of the labels in Design view.

Customizing mailing labels

You customize a label report the same way you customize any other report. A label report has a detail section that contains one or more text boxes. You can add or remove text boxes, move or resize them, set their font properties, and set other text box properties to make the label look the way you want. You can also modify the page setup options if the labels don't print correctly.