How to Create Labels From Microsoft Access Reports

One of the most convenient Access features for many a user is automatically printing mailing labels from your database. The labels are really just a kind of report. These instructions apply to MS Access 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access

1. Open the Database window.

2. Click on the Reports tab.

3. Click New. A dialog box appears.

4. Click Label Wizard.

5. Locate the table or query that is to be used for the labels.

6. Click OK.

7. Follow the wizard's instructions to select the fields and formatting used in the labels.

8. Print your labels when you are satisfied with the result.

Tips & Warnings

• If you're not fully satisfied with the wizard's work, you can customize the look of your labels in Design view.

[jimlemon]

on 1/15/2007 I found that the values entered in Page Setup for columnar labels did not correspond to the printed labels. To ensure that the printed pages conform to these values, the height of the detail field must be set to the same height as that in the Page Setup - Columns dialog.