English

How To: Create mailing labels with Crystal Reports

Summary

Instructions provided describe the procedure for creating mailing labels using Crystal Reports 9.0 and 11.0.

Procedure

Before beginning, create a new personal geodatabase with the desired records in a new feature class. Once completed, follow the steps below:

  1. Start Crystal Reports.
  2. In Crytal Reports 9.0 create a New Crystal Report Document, using the Report Wizard and click OK.

    In Crystal Reports 11.0 create a new Mailing Label Report from the File > New menu and proceed to step 4.
  3. On the Crystal Reports for ESRI Gallery dialog box, select Mail Label and click OK.

    [O-Image] Crystal Reports for ESRI Gallery
  4. Select 'Create New Connection' in the Mailing Labels Report Creation Wizard dialog box.

    [O-Image] Mailing Labels Report Creation Wizard
  5. Select the Access/Excel(DAO) connection.
  6. Navigate to the personal geodatabase that was created at the begining of this article and click Finish.

    [O-Image] Access/Excel(DAO)
  7. Select the table, which is the name of the feature class. Click the arrow to add the table to the selected table list and click Next.

    [O-Image] Select Table
  8. Select the fields that compose the address and use the arrow to add the fields to the selected fields list and click Next.

    [O-Image] Select Fields
  9. Set up the mailing label and click Finish.

    [O-Image] Setup Label
    Note:
    In the design mode, the order of the fields and their placements can be altered.