Mail merge is a function that helps you to simplify repetitive tasks to create personalized documents (Forms, Letters, Address Labels, Envelopes, etc.). You can create a mail merge template that would contain the variables (merge fields) in it. Using the template, you can merge data from Nonprofit Vertical CRM and create the merged documents with accurate values for the variables.

Suppose you have to send personalized letters to numerous leads or create templates for service level agreements or other legal documents. In such cases, you need not manually type the details of each lead in the letters to personalize them. Instead, you can simply create a template with the merge fields from the leads module and later merge the data to get all the personalized letters.

Create Template Folders

To create a template folder

1. Go to Setup > Customization > Templates > Mail Merge Templates.
   
2. In the Mail Merge Templates page, click Create Folder.
   
3. In the Create Mail Merge Templates Folder page, enter the Folder Name.
   
4. Click Save.
   

Create Mail Merge Templates in Nonprofit Vertical CRM Writer

1. Go to Setup > Customization > Templates > Mail Merge Templates.
   
2. In the Mail Merge Templates page, click + Create Template in Nonprofit Vertical Writer.
   
3. In the Create Template in Nonprofit Vertical Writer window, specify the following details:
   
   
   
   • Enter the Template Name.
     
   • Enter the Description 
     

     for
     

     the template.
     
   • Select the Folder from the drop-down list. The template will be stored in the folder that you select.
     
   • Select the Module for which you want to create the template.
     
     The merge fields in the template will be based on the module that you select. You can create mail merge templates for both system-generated modules as well as custom modules.
     
4. Click Create.
   
   A document will be opened in Nonprofit Vertical Writer.
   
5. Click Tools > Mail Merge >Insert Fields and select the field(s) that you want to insert.
   
   
   
   The fields will be inserted in the specified place in Writer template.
   
6. Changes will be saved automatically.
   

Import MS Word Templates

1. Go to Setup > Customization > Templates > Mail Merge Templates.
   
2. In the Mail Merge Templates page, click Import Template.
   
3. In the Import Template window, specify the following details:
   
   
   
   • Click Browse to choose the Microsoft word file that you want to import.
     
   • Enter the Description 
     

     for
     

     the template.
     
   • Select the Folder from the drop-down list. The template will be stored in the folder that you select.
     
   • Select the Module for which you want to create the template.
     
     The merge fields in the template will be based on the module that you select.
     
4. Click Import Template.
   

Send Mail Merge Documents via Email

Once you have created and saved your mail merge templates in Nonprofit Vertical CRM, you can merge the documents with CRM records and email them to the desired customer/s at any time.

To send mail merge documents via email

1. Go to the required module (Leads/Contacts/Accounts/Deals/Custom modules)
   
2. Select the record.
   
   If you wish to send the document to a bunch of customers select the desired records in the Module List View
   

   .
   
3. Click the More icon and click Mail Merge.
   
4. In the Mail Merge popup, select the required document and click Merge.
   
   
   
   You will be redirected to the template in Nonprofit Vertical Writer. You can edit the template if required.
   
5. On the left, under the Complete Merge section, click Email.
   
6. In the Email Merged Document popup, select the email ID that the document should be sent to.
   
7. Enter the details required to send the document as mentioned below.
   

1. • • your account email address
       
     • organization email address
       
     • email address of the record owner
       
   • Email field: Choose which email ID you want to send the mail merge document to - the person's primary or secondary address or an associated CRM user's email as well as any other custom email field. 
     
   • Subject: Enter a desired Subject line for the email.
     
   • Send (Email) As: You have the option of sending this mail merge document inline or as an attachment. 
     
     • Inline: The template content will be part of the email body
       
     • Attachment: The mail merge document will be sent as an attachment with the email.
       
   • Message: Enter a message to the recipient. This will be displayed in the body section of the email.
     
   • Attachment Name: If you choose to send the email as an attachment, enter a name for the attachment.
     
   • Additional Attachment: If you have additional attachments to send, you can browse for the required files and attach them here.
     

   Note that the subject can also contain a merge field of the desired module. Simply click the + icon to insert the merge field as shown in the image below.
   

2. Click Send.
   
   The merged document will be sent to the chosen email IDs.
   

Track Sent Mail Merge Emails

Once you have sent your mail merge documents via email, they can be tracked under the Emails Related List of the associated records (leads, contacts etc). You will check this related list to see the list of emails you have sent to a particular lead/contact and their status. Mail Merge Emails will also feature under this related list.

To view the Emails related list

1. Go to the respective module, say Leads.
   
2. Click the record in question.
   
3. Scroll down to the Emails related list.
   
4. Make sure to select "Emails Sent from CRM".
   
5. You will find the list of emails, the source type
   
   and
   
   the status.
   

View Mail Merge Logs

To view mail merge logs

1. Go to the mail merge document/template in Zoho Writer.
   
2. Click Tools > Mail Merge.
   
3. Click View Mail Merge Logs found right under the Complete Merge section.
   
   
   
   Click the Filter to sort the templates based on their status - such as In Progress, Completed and Failed.
   

What's the difference between tracking mail merge template status under Emails Related List and Mail Merge Logs?

Whereas, in the Mail Merge Logs, you will see the status a particular mail merge template that's been sent to one person or many people. Example, you have sent a template called Service Level Agreement to 5 people. Mail Merge Logs will show the status of that particular template and its delivery status with respect to each recipient it is sent to.

• Email Related List is recipient-based.
  
• Mail Merge Logs is template-based.
  

Delete Mail Merge Template

To import MS Word template

1. Go to Setup > Customization > Templates > Mail Merge Templates.
   
2. In the Mail Merge Templates page, move the mouse pointer over the template.
   
3. Click the Delete icon.