Note: After you import query results into a spreadsheet using a mail merge, the number of records in the spreadsheet may be lower than the number of records in the query results. This happens because records that are marked "Deceased" are removed during the mail merge.
-
Choose the Use Query link on the query Results screen.
-
In the dialog box that opens, click the radio button for Create a Mail-Merge list and then click Go.
- On the New Mailmerge screen, observe and/or make changes to the following:
Mailmerge Name - provide a name for your file
Author - by default will be the name of the Administrator who is creating the mail-merge list
Description - provide a description of the file
Security Category - choose from the drop-down menu; your choice may limit access to the mail-merge list by other administrators
-
Select Log mailmerge as interaction for constituents if you would like to enable this feature.
-
Select the fields to include in the mailmerge by highlighting the fields on the left of your screen and clicking Add Selected. (Use Ctrl + Click to select multiple fields.) Use the Remove Selected button to move any unwanted choices back to the left of your screen.
-
Click Next Step.
-
Click Confirm. The new list should now appear on the Mailmerge List page.
-
Click the Refresh button to update the Status of the list. When the Status indicates that the report has been Generated, you can download the mailmerge list (csv file) using the download icon.