One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.
Note: These instructions are for Access 2010. If you are using an earlier version of Microsoft Access, read Printing Mailing Labels in Microsoft Access.
Note: These instructions are for Access 2010. If you are using an earlier version of Microsoft Access, read Printing Mailing Labels in Microsoft Access.
Difficulty: Easy
Time Required: 30 minutes
Here's How:
- Open the Access database containing the address information you wish to include in your labels.
- Using the Navigation Pane, select the table that contains the information you wish to include on your labels. If you do not wish to use a table, you may also select a report, query or form.
- On the Create tab, click the Labels button in the Reports group.
- When the Label Wizard opens, select the style of labels you wish to print and click Next.
- Choose the font name, font size, font weight and text color you would like to appear on your labels and click Next.
- Using the > button, place the fields you wish to appear on the label on the prototype label. When finished, click Next to continue.
- Choose the database field you'd like Access to sort based upon. After you select the appropriate field, click Next.
- Choose a name for your report and click Finish.
- Your label report will then appear on the screen. Preview the report to ensure that it is correct. When satisfied, load your printer with labels and print the report.
Tips:
- You may wish to sort your labels by ZIP code to meet postal bulk mailing regulations.
- Check your label package for instructions if you're having trouble finding the appropriate label format.
What You Need
- Database with address information
- Labels
- Access 2010
