Using Plugin for MS Word | Online Help - Zoho CRM

Using Plug-in for MS Word

Zoho CRM Plug-in for Microsoft Word allows you to create mail merge documents in Microsoft Word and also from Zoho CRM. You must execute specific operations in both Microsoft Word and Zoho CRM:

  • Microsoft Word Operations
  • Zoho CRM Operations

Microsoft Word Operations

Zoho CRM Plug-in for Microsoft Word helps you to create mail merge templates and mail merge documents in Microsoft Word.

The MS Word related actions are:

  • Sign In
  • Create Mail Merge Template
  • Create Mail Merge Document

Sign In 

To create template, specify your Zoho CRM log in details in Microsoft Word. This will connect Microsoft Word to Zoho CRM.

To Sign In

  1. Open Microsoft Word.
  2. Click  Zoho CRM > Sign In.

  3. In the  Zoho CRM - Login  popup, click  Continue to Sign in.
    You will be redirected to Zoho CRM accounts page in your default browser.
  4. Enter the  Email Address/Phone Number Password , and click  Sign In .
  5. Read the information that the CRM Outlook plugin would like to access and click Accept.
    Please note that once you click Accept, it will take approximately 20 seconds for you to sign-in.
Note
In Microsoft Word 2000/2002/2003, the Zoho CRM tab is displayed in the Main menu.

Create Mail Merge Template

Mail Merge template is a model / pattern of your mail merge document which contains variables (Example: Customer Name, Address, etc.,) and standard content. While creating mail merge template, you can replace the variables with the required CRM fields using Zoho CRM plug-in for Microsoft Word. You can create mail merge templates for Form Letters, Address Labels, Envelopes etc. See Also Sample Template

Note that you can create mail merge templates for Leads, Contacts, Deals and Custom modules in Zoho CRM.

To create mail merge template

  1. Open Microsoft Word.
  2. Click Add-Ins > Zoho CRM > Create Template.
  3. In the  Create Mail Merge Template Wizard, do the following
    • Select the CRM Module for which you want to use the template, from the Primary Module drop-down and click Next. 
      The selected module and its fields are displayed.
    • Select the required fields from the Fields drop-down and click Insert Fields
    • Click the Module drop-down again to select the Secondary Module or the Related Modules*.
    • Select the associated fields from the Fields drop-down and click  Insert Fields.
      The selected fields are inserted in the template.

The mail merge template is created and you can save the template with .doc/.docx extension in your local machine (if needed). Please use .doc extension if you have lower version of MS Word i.e., 2000 to 2003.

(*)Secondary Module/Related Module: When you create a mail merge template for a module, you will find fields from a few other related modules under the list of merge fields. For example, when you create a template for Deals, you will find fields from Accounts, Contacts and Campaigns modules - these can be inserted in your template. In this case, while Deals is your primary module for which you are creating the template, AccountsContacts and Campaigns are the secondary modules or related modules.

Note that the related modules are also populated from any custom lookup field that you create in a module.

For example, assume that you have created a lookup field in the Leads module called Associated Builders and you link a custom module called Builders here. When you create an email template for Leads, you will also find fields from the Builders module under the list of merge fields. These are also called the secondary modules or related modules.

The following table provides the list of primary modules and their associated secondary modules:

Primary Module Related Modules / Secondary modules
Leads - - - Custom lookup/module
Accounts - - - Custom lookup/module
Contacts Accounts - - Custom lookup/module
Deals Accounts Contacts Campaigns Custom lookup/module
Custom modules - - - Custom lookup/module

Create Mail Merge Documents

You can create mail merge documents for Leads, Accounts, Contacts, Potentials in Microsoft Word by merging CRM data with an existing mail merge template from Zoho CRM or with a new template, created in MS Word.

To create mail merge document using a new template

  1. Follow the above steps to create the template.
  2. Choose " Upload to Zoho CRM and continue merging" and click  Next.
    • Template Name: Specify the template name and select the required document format.
    • Module: By default, the selected primary module is displayed.
    • Description: Enter any additional comments.
    • Click " Upload & Merge "
      The template is uploaded to Zoho CRM. You can view these templates from Settings > Setup > Customization > Templates > Mail Merge Templates in Zoho CRM.
  3. Click " Continue " to start the merge process.
  4. In the  Create Mail Merge Document wizard, do the following:
    • Select a list view from view drop-down list and the related records is displayed.
      You can enter the record information in search box to get the required records.
    • Choose the required record(s) from the Available Records list box and click the Forward Arrow.
      The chosen records are now displayed in Selected Records list box.
    • Click Merge Now.
      The mail merge document for the selected record(s) gets created and displayed in the Microsoft Word.
Note
You can also choose other options such as:
  1. Upload to Zoho CRM : On choosing this option, your template gets uploaded to Zoho CRM and you can continue the merge process in Zoho CRM (Refer: Zoho CRM Operations)
  2. Do Not Upload to Zoho CRM : On choosing this option, your template will not be uploaded to Zoho CRM and you can continue the merge process in MS Word.

To create mail merge document using an existing mail merge template
  1. Open Microsoft Word.
  2. Click Add-Ins Zoho CRM > Merge Template.
  3. In the Create Mail MergeTemplate wizard, select the main CRM module and click Next.
  4. In the  Create Mail Merge Document wizard, do the following:
    • Choose the required mail merge template from the drop-down list and click Next.
    • Select a list view from view drop-down list and the related records is displayed.
      You can enter the record information in search box to get the required records.
    • Choose the required record(s) from the Available Records list box and click the Forward Arrow.
      The chosen records are now displayed in Selected Records list box.
    • Click Merge Now.
      The mail merge document for the selected record(s) gets created and displayed in the Microsoft Word.
Note
  1. You can save the mail merge documents in your local machine and print offline, whenever required.

Zoho CRM Operations

Zoho CRM Plug-in for Microsoft Word helps you to create mail merge documents in Zoho CRM, by merging the corresponding mail merge template with Leads, Contacts, Accounts or Deals or Custom modules data.

The Zoho CRM related actions are:

  • Create Mail Merge Template Folder
  • Import Mail Merge Templates
  • Create Mail Merge documents

Create Mail Merge Folder

This option allows you to store all the MS Word mail merge templates in specific folder(s). You can also set folder-level permission for Zoho CRM users.

To create mail merge folder

  1. Go to Setup > Customization > Templates > Mail Merge Templates.
  2. In the Template Explore r page, click Create Folder.
  3. In the  Create Mail Merge Template Folder, do the following:
    • Folder Details: Specify the Folder Name in the corresponding field.
    • Accessibility Details: Select one of the following options:
      • All Users are allowed to view this Template Folder: Select if you would like to enable the folder access for all the users.
      • Show this Template Folder only to me: Select if you would like to enable the folder access only to you.
      • Allow the following users to view this Template Folder: Select the users or user roles that can access the folder.
  4. Click Save.

Import Mail Merge templates

This option allows you to add the MS Word mail merge templates in Zoho CRM. These templates can be later merged with the corresponding CRM module(s).

To add mail merge templates

  1. Log in to Zoho CRM with your User name and Password.
  2. Go to Setup > Customization > Templates > Mail Merge Templates.
  3. In the Template Explorer page, click Import Template.
  4. In the  Import Template dialog-box, specify the following:
    • Select File : Browse the MS Word template from your local system.
    • Folders : Choose the folder to store the selected template.
    • Module : Select the module (Leads / Accounts / Contacts / Deals / Custom Modules) for the MS Word template.
      The template is available only for the specified module.
    • Description : Specify any additional comments.
  5. Click Import Template.

Create Mail Merge Documents

The Mail Merge link helps you to merge the template with the list of Leads, Contacts, Deals or Accounts or any other custom modules and create the corresponding mail merge documents.

Before creating mail merge documents, you should:

  1. Configure your browser to enable ActiveX control. See Also Configure web browser to install ActiveX Control
  2. Install the Adventnet.CAB file from Zoho CRM server.
Note
  1. While installing the cab file for the first time, you can select the option "Always install software from Adventnet" from More Options.

To create single mail merge document

  1. Log in to Zoho CRM with your Username and Password.
  2. Click Contacts tab.
  3. In the Contacts home page, select the check box corresponding to the contact.  
  4. Click More Actions > Mail Merge.
  5. In the Mail Merge dialog box, choose the corresponding Mail Merge Template to be merged with the selected contact.
  6. Click Merge.
    The mail merge document for the selected contact gets displayed in the Microsoft Word.
Note
  1. You can save the mail merge document in your local machine and print offline, whenever required.
  2. Follow the same procedure to create mail merge documents for Leads, Accounts, Deals and other Custom Modules.

To create multiple mail merge documents

  1. Log in to Zoho CRM with your Username and Password.
  2. Click Contacts tab.
  3. In the Conatcts home page, select the check box(es) to select multiple contacts.  
  4. Click More Actions > Mail Merge.
  5. In the Mail Merge dialog box, choose the corresponding Mail Merge Template to be merged with the selected Contacts.
  6. Click Merge.
    The mail merge documents for the selected Contacts gets displayed in the Microsoft Word.
Note
  1. You can save the mail merge documents in your local machine and print offline, whenever required.
Follow the same procedure to create mail merge documents for Leads, Accounts, Deals and other Custom Modules.

Usage Limits

Particulars Trial Version Licensed Version
Number of records that can be merged Max 30 records Unlimited
Number of mail merge templates that can be imported Max 5 Templates Unlimited
Number of folders that can be created Unlimited Unlimited
Maximum file size for each template 2 MB 2 MB

    Access your files securely from anywhere

      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









                                                                                                              • Related Articles

                                                                                                              • MS Word Plug-in - An Overview

                                                                                                                The Zoho CRM Plug-in for Microsoft Word is an easy-to-use productivity tool to create mail merge documents on-the-fly. It allows you to create mail merge documents in MS Word using Zoho CRM data or from Zoho CRM using MS Word template. The mail merge ...
                                                                                                              • Installing the MS Word Plug-in

                                                                                                                System Requirements The basic system requirements to install the Zoho CRM Plug-in for Microsoft Word are below: Hardware x486 with minimum of 256 Mb RAM; minimum 10 Mb disk space Operating System Windows 7, 8, and 10 Software Microsoft Word 2010 / ...
                                                                                                              • Using the MS Outlook Plug-in (Windows)

                                                                                                                We have deprecated download of MS Outlook Plug-in. The Plug-in will not be functional after May 31st, 2021. Read more about it here.  Using the Zoho CRM Plug-in for Microsoft Outlook, you can do the following: Add records to Zoho Category Remove ...
                                                                                                              • Using Zoho CRM Plug-in for Microsoft Outlook (Mac)

                                                                                                                We have deprecated download of MS Outlook Plug-in. The Plug-in will not be functional after May 31st, 2021. Read more about it here.  Using the Zoho CRM Plug-in for Microsoft Outlook, you can do the following: Synchronize (two-way) Contacts, Tasks ...
                                                                                                              • Installing the MS Outlook Plug-in (Windows)

                                                                                                                We have deprecated download of MS Outlook Plug-in. The Plug-in will not be functional after May 31st, 2021. Read more about it here.  Install Zoho CRM Plug-in Installing the Zoho CRM Plug-in for Microsoft Outlook requires the following steps to be ...
                                                                                                                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