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.
Other People Are Reading
Instructions
-
-
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.
-
1
Tips & Warnings
If you're not fully satisfied with the wizard's work, you can customize the look of your labels in Design view.
More Like This
Comments
-
jimlemon
Jan 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. -
jimlemon
Jan 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.
