Microsoft Office Tutorials and References
In Depth Information
Creating Mailing Labels
10. Choose the field(s) by which you want to sort the records; then
To sort by last name within zip code, for example, choose the
ZIPPostalCode field and then the Last Name field.
11. Type a name for the report.
12. Click Finish.
The wizard creates the report for you. Figure 2-10 shows a report
created by the wizard — just a regular report, but the layout will fit on the
type of labels you specified.
will print on
If the label report looks good in Report view, print it on a blank piece of
paper before you start printing sheets of labels. Hold the printed sheet up
to a blank sheet of labels, and see whether the names and addresses line up
with the labels. This method prevents you from wasting sheets of expensive
labels while you refine your label report. Chapter 1 of this minibook
discusses how to print reports.
Behind the scenes in a mailing-label report
The Label Wizard makes a report that looks like Figure 2-10 in Design view.
You see the fields and text that you told the wizard to include, followed by
enough blank space to reach down to where the text should start on the next
label. When more than one field (or text) appears on a line, the Label Wizard
cleverly writes expressions (starting with =) that use the & operator to
concatenate (glue together) the information. In expressions, the wizard encloses
each field name in square brackets [ ] because, for field names that
contain spaces, these brackets prevent the spaces from confusing Access. The
wizard also uses the Trim() function to eliminate any extra spaces at the
ends of fields.