FAQs: Mail Merge Templates

FAQs: Mail Merge Templates

How to insert custom look-up fields in the mail merge template?

At present, you cannot insert Custom lookup fields and check box fields in the mail merge template. However, you can insert all default lookup fields such as Parent Account, Account Name, Vendor Name and more.

How to insert my Organization Logo in the mail merge template?

You can't insert the company logo using merge fields. However, you can manually add your Organization Logo by using the Insert picture option in your mail merge template.

When I create a new custom field in Zoho CRM, will it get automatically updated in the Insert Merge Fields dialog?

Yes, when you create custom fields in Zoho CRM, they get added automatically to the "Insert merge fields" list. However, you need to sign out of the Zoho CRM Plug-in for MS Office and sign in again to insert corresponding custom fields. Use these same steps to insert merge fields in Zoho Writer as well.

How do I create Avery 5160 Address Labels?

You can create Avery 5160 Address labels using the Zoho CRM plug-in for Microsoft Word.

How to edit the mail merge template in Zoho Writer?

Mail Merge templates created using Zoho Writer can be edited through these steps.
  1. Click Setup > Marketplace > Zoho > Zoho Writer.
  2. In the Zoho Writer Add-on page, click Open Mail Merge Templates, if you already have mail merge templates.
  3. In the Mail Merge Templates page, select any template from the list.
  4. The template will be opened using Zoho Writer.
  5. Modify the template, according to your requirement and click the Save icon.

How to add images to the mail merge template?

You can add an image to the Zoho Writer's mail merge template by following these steps:
  1. Click the [Module] tab. Module refers to the Leads, Contacts, Accounts, etc. tabs.
  2. In the Home page, select the list view to filter the records that are required.
  3. Select the check box (es) of the records.
  4. Click More Actions MailMerge.
  5. In the Mail Merge popup window, do the following:
    • Choose the template from the drop-down list. Only the templates created for the specific record type will be listed.
      For example, if you select the lead records to merge, only the template that is created for leads will be listed in the drop-down box.
    • Choose Zoho Writer or Microsoft Word to open the template.
  6. In the template click Insert Image to insert an image.
  7. Click Save.

Why is the Merge Template Print option not available for certain modules?

  1. The Mail Merge Templates option is restricted to Leads, Contacts, Accounts, and Deals.
  2. Email Templates are module-specific, that is, appear only if there are any email templates created for the module in question.
  3. Inventory Templates are restricted to Inventory Modules only.
  4. The additional Print options (Email, Mail Merge and Inventory templates) are available for all paid Zoho CRM accounts. For Free and Trial accounts, only the default print option is available.

How can I send mail merge documents through email using Workflow rules?

Yes, you can send documents created through mail merge via email using workflow rules with the help of functions. Read more about creating mail merge templates.

To set workflow rule for sending mail merge documents
  1. Go to Setup > Automation > Workflow rule.
  2. Click +Create Rule.
  3. In Create New Rule, choose a module from the drop-down list.
  4. Enter Rule Name and Description.
  5. Click Next.
  6. In the Workflow configuration page, select When do you want to execute the rule?
  7. Choose a criteria, if you want the rule to execute for selected records.
  8. In Instant Action, choose Functions.
  9. In Configure Functions, select Write your own.
  10. Enter Function name and Display name.
  11. Click Edit Arguments.
  12. In the Edit Argument window, you can change the function name entered previously.
  13. In Argument Mapping, enter the record ID and email ID and map it with the right field.
    Use # to add a merge field.
  14. Click Save.
  15. Enter the below function.
    1. resp = invokeurl
      [ url :"https://zohoapis.com/crm/v2/settings/email_templates/653844000009571031/actions/print_preview?record_id=%22 + dealId
      type :GET
      connection:"mailmergeconnection"
       ]; //Create connection and pass the required mail merge id here
      content = resp.get("email_template_preview").get("body");
      fmp = Map();
      fmp.put("email",zoho.loginuserid); //Set the from address as needed
       emaillist = List();
      emp = Map();
      emp.put("email",email);
      emaillist.add(emp);
      mp = Map();
      mp.put("subject","Set as per your requirement");
      mp.put("content",content);
      mp.put("to_address",emaillist);
      mp.put("id",dealId);
      mp.put("template_id","653844000009571011");//Pass the required template id here
      mp.put("from_address",fmp);
      mp.put("attachment_name","Deal Won Template");//Set the attachment name as needed
      datalist = List();
      datalist.add(mp);
      paramp = Map();
      paramp.put("data",datalist);
      resp1 = invokeurl
      [
      url :"https://www.zohoapis.com/crm/v2/Deals/actions/send_mail?type=mailmerge%22
      type :POST
      parameters:paramp.toString()
      connection:"mailmergeconnection"
       ];
      info resp1;

How to insert the "Next Record" field in the Address Label template?

You can insert the "Next Record" field directly from the "Insert Field" box, since it is not included in the Merge Fields list.
  1. Click Setup > Customization > Templates > Mail Merge and select the template that you need.
  2. Select Next Record and add it to the Address Label template.

What is the maximum number of contacts that can be associated with an Account for mail merge to work?

Mail merge helps you create personalized documents by creating a template that contains the variables (merge fields) which incorporate values from a record. For example, you can place a merge field in an email template to retrieve the customer's name instead of a generic term.
You can associate up to 100 contacts with an account to use mail merge. For example, if you have 130 contacts associated with one Account record, mail merge will only work for the first 100 contacts.



    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION








                                You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                    Manage your brands on social media

                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                        Zoho Marketing Automation

                                          Zoho Sheet Resources

                                           

                                              Zoho Forms Resources


                                                Secure your business
                                                communication with Zoho Mail


                                                Mail on the move with
                                                Zoho Mail mobile application

                                                  Stay on top of your schedule
                                                  at all times


                                                  Carry your calendar with you
                                                  Anytime, anywhere




                                                        Zoho Sign Resources

                                                          Sign, Paperless!

                                                          Sign and send business documents on the go!

                                                          Get Started Now




                                                                  Zoho TeamInbox Resources



                                                                          Zoho DataPrep Resources



                                                                            Zoho DataPrep Demo

                                                                            Get a personalized demo or POC

                                                                            REGISTER NOW


                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • Related Articles

                                                                                                  • 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 which contains variables (merge fields), which will merge ...
                                                                                                  • Creating Inventory Templates

                                                                                                    With the Zoho CRM - Inventory Templates functionality, you can customize the Quote, Purchase Order, Sales Order and Invoice print layout as per your business requirements. As part of the template customization, you can change the fields in the print ...
                                                                                                  • Troubleshooting Email Templates

                                                                                                    1. Product details are not populated in the table created in a template. Product details will only be available if the default product table in the template has been added. If the fields in the Product Details section are added separately, the values ...
                                                                                                  • FAQs on Audit Logs

                                                                                                    What is an audit log and how is it helpful? An audit log, also known as an audit trail, is a record of all the actions that each user in your CRM account performs, displayed in chronological order. An audit log can help identify which user performed ...
                                                                                                  • FAQs: Email Templates

                                                                                                    Can I include only the first name or last name in the email template? Yes, you can use only the first name or last name in the email template as per your requirement. Let's assume you want to send an email where only the First Name of the lead needs ...
                                                                                                    Wherever you are is as good as
                                                                                                    your workplace

                                                                                                      Resources

                                                                                                      Videos

                                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                      eBooks

                                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                      Webinars

                                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                      CRM Tips

                                                                                                      Make the most of Zoho CRM with these useful tips.



                                                                                                        Zoho Show Resources