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.
Difficulty: Easy
Time Required: 30 minutes
Here's How:
- Open the Access database containing the address information you wish to include in your labels.
- Choose the green Reports icon in the Objects pane of the Database window.
- Choose the green New icon from the toolbar located on top of the Database window.
- Single-click on the Label Wizard line in the New Report window that appears. Then choose the table or query that contains your address information from the pull-down menu in that same window. After making both selections, click OK.
- 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
