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.
    Use the Label Wizard

    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.
    Use the Label Wizard

    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.
    Use the Label Wizard

    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.
    Use the Label Wizard

    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.

    Use the Label Wizard
  8. Give your report a name and click Finish.
    Use the Label Wizard

Access creates the mailing labels and displays them on screen.

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.