Use custom queries to create mailing labels.

1. Create a query.
2. Click Show Results.
3. By default, all records are selected. If you prefer, select only the records you want to create labels for by clicking the top check box then selecting only certain records.
4. Near the top of the page, click , select Labels, and make a selection:
   • Individual Labels— Outputs the report results as an address label list (one label per family member) that displays in a new tab or window. Example: Joe Smith 123 Elm Street Happy Valley, SC 29501 and Sue Smith 123 Elm Street Happy Valley, SC 29501 and Jack Smith 123 Elm Street Happy Valley, SC 29501
   • Household Labels— Outputs the report results as an address label list (one label per household) that displays in a new tab or window. Whereas family labels will include just the names of primary family members, household labels will include the children's names as well if there is room. If not, the label will simply read "The Smith Family", for instance: Joe, Sue, and Jack Smith 123 Elm Street Happy Valley, SC 29501 or The Smith Family 123 Elm Street Happy Valley, SC 29501
     CAUTION:

     • Address linking— In order for members of a household to display on the same Household label, their mailing address must be linked on their profile records. If their mailing address is not linked on their records, each member will print on separate Household labels. To link addresses, on the profile record you want to link, click Link address, select the record you want to link to, then click OK.
     • Different last names— If spouses have different last names, the household label will still include only the last name of the individual with the highest family position ("head" as opposed to "spouse" or "other", for example) when all names won't fit the label: "The Smith Family".
   • Family Labels— Outputs the report results as an address label list (one label per family) that displays in a new tab or window. The address includes only the names of primary family members: Joe and Sue Smith 123 Elm Street Happy Valley, SC 29501
5. Specify whether you want to sort your results alphabetically or by ZIP code.
6. If you're including only selected records, click Selected only. If all records are selected, you will not see this option.
7. Click Run.
8. The output downloads as a PDF. To open it, follow the notification displayed by your browser. You can also get it from the report log.
   Note:

   • Print using Actual Size (100%) and make sure the Fit to Page option is not selected.
   • Select Labels as Print Type. If your printing device doesn't show Labels as an option, select Heavyweight or Cardstock.

Steps for using custom queries to generate a mail merge with Microsoft Office

1. Create a query.
2. Near the top of the page, click , select List (csv), and select an option. You can export your results as a CSV file in any of the label formats.
3. Import the CSV file into Excel, and make any formatting changes you want.
4. Save as an Excel spreadsheet file.
5. Import into Word using its mail merge feature. Detailed instructions are on Microsoft's website.