Use the Label Wizard

For bulk mailings, nothing is more efficient than a stack of well-organized mailing labels. The Access Label Wizard helps you quickly create labels using data from your Access database. The Label Wizard supports a huge variety of label sizes and brands. In this lesson, you will use the Label Wizard to create a set of mailing labels.

1. Open the table or query that contains the data for your labels.
2. Click the Create tab.
3. Click the Labels button.
   

   The Label Wizard dialog box appears, listing the various types of labels by product number. Simply scroll down and find the number that matches the one on your label box.

   If you can't find your label type, click the Customize button and tell the Label Wizard how to set up your nonstandard labels.

4. Specify your label's manufacturer and label size and click Next.
   

   The next window of the Label Wizard lets you change the font used in your label.

5. Select the font and font formatting options you want to use for your label and click Next.
   

   It's time to tell the Label Wizard which fields you want to use.

   If you want to place fields on separate rows, you'll need to press Enter in the Prototype label area to move to the next row before inserting the field.

   Also, if you want certain text to appear on every label—such as a comma between the city and state—you can type the text in the Prototype label area.

6. Double-click each field you want to use. Click Next.
   

   Next you can determine the order of your labels by sorting.

7. Specify the fields that you want to use to sort your labels. Click Next.

   You can sort by multiple fields if desired.

   
8. Give your report a name and click Finish.
   

Access creates the mailing labels and displays them on screen.