In This Article:

    Mail Merge: E-mail Merge from a New Query

    In This Article:

      1. Open the Word Processor by choosing Manage, Documents and then Word Processor from the main menu.
      2. From the Options drop-down field, select Run a Mail Merge with additional options. The Mail Merge window opens.
      3. Select the Run Query button located at the top of the screen.  Note:  If a previous query results appear, ignore and click the Run Query button.
      4. The Query Wizard launches.
      5. Select the Create new query option at the top of the Query Wizard window. 
      6. Follow the steps in the Advanced Query Wizard: Creating a Mail Merge Query article 
      7. The Query Wizard closes.  There is now a count of returned records listed next to the Run Query button.
      8. Once you have created your query, for the purpose of sending an email, select the After the merge, I want to email the results using the email addresses in this column. Then, in the drop-down field, select the appropriate column where the email addresses are listed in the query results. Selecting this option will then allow you to choose if you want to send an email or an email with a merged attachment.
      9. Select the option you would like on the I want the merge to create line. This gives you the choice of sending just an email or an email with an attachment.
      10. If you would like to record that these constituents received this mailing, select the Mailing button. The first time you do this, you will need to create a Mailing ‘folder’.  When the Mailings window appears, select the Add button; enter a Name and Description for this mailing folder. Once you Save this information, the ‘Mailing folder’ name appears on the mail merge screen.  IMPORTANT: This ‘mailing folder’ will capture the information of those constituents who are in the results of your query and will be receiving this mailing.  This will allow you to exclude them from future mailings, should you so choose. For example, you may send mailings to donors of $1,000+, but want to exclude any donors matching these criteria if they have already received this mailing. When you run your query of $1,000 or more, select the Mailing button and choose the mailing the $1,000+ donors have received, Salsa CRM will exclude anyone who is already in this ‘mailing folder’.  This way you know that someone will not receive the same mailing twice.
      11. If, on the I want the merge to create option, you chose to include an attachment option, you will be able to select the document you wish to use as the merged attachment by selecting the Select Document button.  NOTE: Email attachments, which are created using the word processor, can be text, html, doc and .rtf type documents.
      12. Select the Select Document to select which document will serve as the body, or text, of your email. These documents, created in the word processor, can be html or text only. NOTE:  When you choose to save an email to a constituent record, it will appear under the Documents node of the constituent record. Once the document has been selected, the document description will appear to the right of the button. 
      13. Select the Options button to choose the Print Merge Options you would like to apply to this merge. On the Print Merge Options window you have the following options:  
          • File Format Options: Save a merged document as a PDF and/or Save the merged ‘.rtf’ document as a ‘.doc’ file. (If a letter was created using the built-in word processor, the file type is typically ‘.rtf’.)
          • Save to Database Options: Allows you to save the merged email content and/or the merged attachment document to the constituent’s record.
          • Household and Deduplication Options: Choose to allow only one merge per: Constituent ID, Address based on Line 1 and Postal Code and Email Address. (If you select Constituent ID, Spouse ID will become available for selection, likewise, if you select Address Line 1, Line 2 becomes available for selection.)
            • The deduplication options ensure that multiple mailings are not sent to the same constituent or address. By selecting the options shown in the Print Merge Options window, only one letter will be generated. The Constituent ID option will merge any records that have the same Constituent ID. The document will be saved to the constituent’s record.
            • Consider the ‘Allow only one merge per Constituent ID or Spouse ID’ options. If the query results list a Constituent ID that is listed previously in the results, Salsa CRM will not send an email to this duplicate constituent.
            • Consider the ‘Allow only one merge per Email Address’ option. This indicates to Salsa CRM that you only want one email to be sent to each email address. Once you have made your selection(s), select the OK button.
          • Enter the email address in the From, CC, and/or BCC fields.
          • Enter the Subject and an Attachment Name
      1. Once you have selected the Options, select the Run Mail Merge button. The Results tab opens; all of the constituents from the query results are listed on this screen.  In the top of the screen Salsa CRM lists the Total Records, Success Count, Ignored Count, and Failed Count.
      2. The Results screen allows you to view the results of the Attached Document and Email Content. This screen allows you to open and edit the email content and the email attachment. Select the View All button or double-click on the constituent listing for whom you would like to modify the email and/or attachment.
      3. Click to Edit Content, or Edit Attachment (both are optional).  Once editing is complete, click the Save button.
      4. Click to send the email from your preferred method.  Send emails to a known account first in order to check the content and attachment is recommended.
      Was this article helpful?
      0 out of 0 found this helpful
      Have more questions? Submit a request



      Article is closed for comments.