- Create a query of the records (needing the labels)
- Extract the fields needed for the labels (e.g., constituent name, address information, and constituent code) using Export.
- In Crystal Reports, select File, New Report from the menu bar.
- Select Mail Label from the Report Gallery. Click Data File, browse for the exported data file, highlight it, and click Add. If the Select Tables screen appears, click Select All, then OK, then Done.
- On the Links tab, click Tables. Move any tables from the Invisible Tables box to the Visible tables box and click OK.
- Click Smart Linking and then click Next.
- On the Fields tab, highlight Constituent Name in the list of exported fields and click Add. Do this for each field wanted on the label.
- Create a formula representing the City, State, and ZIP Code fields formatted with commas and spaces. On the Fields tab, click Formula. Type a formula name (e.g., CityStateZip) and click OK. Create the following formula:
- Click Accept.
- The newly created formula field is displayed under the database fields. Highlight the formula and click Add.
- The formula should now be listed under the Report Fields below Constituent Name. Click Next.
- On the Label tab, select the mailing label type. If Predefined Label is selected, the label specifications fill in automatically. However, if User-Defined Label is selected, you can create a custom label size.
- Enter the label size, gap between labels, page margins, and printing direction. Click Next.
- On the Select tab, selected records can be filtered from the data file. If all the records in the data file are accurate, changes do not need to be entered.
- Click Preview Report.
- To make changes, select Report, Report Expert from the menu bar.
- Select File, Print from the menu bar to print labels.
Connect and collaborate with fellow Blackbaud users.