Creating Mailing Labels



  1. Begin by creating a new report.


    Click the New button.

    Step 1
  2. Click the Mail Label list item.

    Step 2
  3. Click the OK button.

    Step 3
  4. The Mailing Labels Report Creation Wizard dialog box enables you to define the label type and select the data that will appear on your report. This dialog box enables you to select the query to create mailing labels, select fields for the labels, define custom label formats, and define criteria to filter the data so that only a subset of that data displays on the report. You first select a query to use for the mailing labels.


    Click the vertical scrollbar.

    Step 4
  5. You want to use the LABEL query for the report.


    Click the LABEL list item.

    Step 5
  6. Click the Add button.

    Step 6
  7. Click the Next > button.

    Step 7
  8. After selecting the query, you need to select the fields that you want to display on the mailing labels. To select individual fields, you highlight the field name and click the Add button. To select all the fields in one step, you use the Add All button. In this example, you will select all the fields.


    Click the Add All button.

    Step 8
  9. The fields have been selected. Next, you need to define the mailing label type.


    Click the Next > button.

    Step 9
  10. Crystal Reports has included templates of some of the most popular Avery labels. The Label Size and Page Margins fields on this page are set by default to the correct values for the Avery label selected. If you select User-Defined Label in the Mailing Label Type field, you need to enter values that match the label type you are using.

    Step 10
  11. For this example, you are going to use the Address (Avery 5262) template.


    Click the Mailing Label Type list.

    Step 11
  12. Click the Address (Avery 5262) list item.

    Step 12
  13. Next, specify how the labels should appear when printed.


    Click the Across Then Down option.

    Step 13
  14. The label information has been selected. Next, you can optionally create a criteria expression.


    Click the Next > button.

    Step 14
  15. This step is optional and enables you to select certain rows based on selected criteria. To do this, you select a field, add it, and specify the criteria that will filter the data so that only a subset of that data displays on the mailing label report. For this example, you will not select any criteria.


    Click the Finish button.

    Step 15
  16. The results appear on the Preview page. Save the report.


    Click the Save button.

    Step 16
  17. Enter the desired information into the File name field. Enter

     a valid value
     "Mailing Labels"

    Step 17
  18. Click the Save button.

    Step 18

In this topic, you created Avery mailing labels containing address information from the PeopleSoft database. If you are not using an Avery label, you have the option to define parameters for a custom layout.

Table of Contents  Start Topic