CRM Help

Managing Mail Merge Templates

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 Zoho CRM and create the merged documents with accurate values for the variables.
Suppose you have to send personalized letters to numerous leads. 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

Template folders are useful to manage the different mail merge templates that you have created.

To create a template folder

  1. Click Setup > 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 Zoho Writer

Zoho Writer is an online word processor that allows you to create and share documents online. You can create mail merge templates in Zoho Writer and use CRM data (Leads, Accounts, Contacts and Potentials) to create mail merge documents.

To create template in Zoho Writer

  1. Click Setup > Templates > Mail Merge Templates.
  2. In the Mail Merge Templates page, click Create Templates in Zoho Writer.
  3. In the Create Template in Zoho 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.
  4. Click Create.
    A document will be opened in Zoho Writer.
  5. Click Insert Merge Fields and select the field(s) that you want to insert.
    The fields will be inserted in the specified place in Writer template.
  6. Click the Save icon to save the template.

Import MS Word Templates

Mail Merge templates can also be created in Microsoft Word and you can import those templates in Zoho CRM. To use this functionality, you need to purchase the Zoho CRM plug-in for Microsoft Office. Note that, for merging the data, this feature is only supported in Internet Explorer 6 and above. See Also Zoho CRM Plug-in for MS Office
Here is a Sample Template.

To import MS Word template

  1. Click Setup > 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.

Delete Template

To import MS Word template

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

Top