Skip to main content

How do I generate address labels?

Describes how to generate and print address labels from query results.

You will need the Reporting permission to perform this action.

Printing address labels is handy for mailings such as giving statements and newsletters. You build a list of people in Reporting > Query Builder, then turn that list into printable labels using the Address labels bulk action.


Generate address labels

  1. In the left-hand navigation, go to Reporting > Query Builder in the left-hand navigation menu, with Data Source set to People.

  2. Build a query that returns the people you want labels for, then click Run Query.

  3. Above the results, open the Bulk Actions menu and choose Address labels.

  4. In the Address Labels window, choose a Template. Once a template is selected, the rest of the options appear.

  5. Set the options described below, then click Generate to download your labels.

The options are as follows:

  • Template - the Avery label sheet you are printing on. Options are Avery Label 5160 (1" x 2-5/8") and Avery Label 5163 (2" x 4"). This field is required.

  • Grouping - who gets a label. Individual gives each person their own label; family-based options print one label per household, listing the head first and spouse second (for example, Don and Marie Lavender). Turn on Use goes by name to print preferred names (nicknames) instead of legal first names.

  • Ordering - how the labels are sorted, such as by last and first name or by zip code.

  • Format - the file type of the output: MS Word (the default) or CSV.

  • Count - the number of labels to print per grouping. Defaults to 1.

  • Starting Label - the label position to start printing from. Positions run left to right, top to bottom, which is useful when the first sheet is partially used.

  • Effective Date - an optional date used to determine each person's address and status as of that date.

Tip: Labels are only generated for people who have an address on file and are not marked deceased.

Other Helpful Articles

Did this answer your question?