1. Home
  2. Computing & Technology
  3. Databases

How To Print Mailing Labels in Microsoft Access

By Mike Chapple, About.com

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:

  1. Open the Access database containing the address information you wish to include in your labels.
  2. Choose the green Reports icon in the Objects pane of the Database window.
  3. Choose the green New icon from the toolbar located on top of the Database window.
  4. 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.
  5. When the Label Wizard opens, select the style of labels you wish to print and click Next.
  6. Choose the font name, font size, font weight and text color you would like to appear on your labels and click Next.
  7. Using the >> button, place the fields you wish to appear on the label on the prototype label. When finished, click Next to continue.
  8. Choose the database field you'd like Access to sort based upon. After you select the appropriate field, click Next.
  9. Choose a name for your report and click Finish.
  10. 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:

  1. You may wish to sort your labels by ZIP code to meet postal bulk mailing regulations.
  2. Check your label package for instructions if you're having trouble finding the appropriate label format.

What You Need:

  • Database with address information
  • Labels
More Databases How To's

Explore Databases

More from About.com

  1. Home
  2. Computing & Technology
  3. Databases
  4. Microsoft Access
  5. Tutorials
  6. How to Print Mailing Labels in Microsoft Access

©2008 About.com, a part of The New York Times Company.

All rights reserved.