Microsoft Plugin Integration

Microsoft Plugin Integration

Zoho Creator Plug-in for MS Word

Note:

·       This Zoho Creator plug-in is compatible with MS Word 2010 (and earlier versions) that is installed in Windows 7 or any earlier version of Windows.

Introduction

Zoho Creator plug-in for Microsoft (MS) Word is a simple yet powerful tool to create mail merge documents using data stored in Zoho Creator. It allows you to seamlessly import field values into your MS Word document, directly from your Zoho Creator apps. You can simply insert the required merge fields to create templates that can be reused, create a fresh document for a unique purpose or create a set of documents with different field values from your Zoho Creator apps. For example, a sales executive can use this plug-in to draft a mail to his manager with his sales details for the day. Similarly, a contractor can use this plug-in while drafting contract documents to retrieve his contract info that is stored in their Zoho Creator app.

High level points of using Zoho Creator plug-in for MS Word:

1.     Install the Zoho Creator plug-in for MS Word.

2.     Log in to your Zoho account to use the plug-in.

3.     Import the required field values to create your mail merge documents.

4.     Save your document for any further use.

Installation

1.    Download the plug-in installer and run it. (Click here to download)

2.     Follow the on-screen instructions carefully and proceed with the installation till you see the Installation complete message. 


After successful installation, you can start using this plug-in to create mail merge documents as mentioned below.

Create Mail Merge documents

1.    Access MS Word.

2.     Click on Add-Ins. Your installed Add-Ins will appear.

3.     Select Zoho Creator from the drop-down, as shown below.

4.     Select Sign In, as shown below. You will be prompted to log in to your Zoho account.


5.     Enter your account credentials.


6.     Click on Sign In.

7.     If you have Two Factor Authentication enabled,

           I.         Go to https://accounts.zoho.com

         II.         Click the Two Factor Authentication link. The authentication page appears.

        III.         Click Manage Application Specific Passwords. A pop-up appears.

                      i.         Enter the Device (or) App Name in the text box.

                     ii.         Specify the Current Password that is used to log into Zoho.

                    iii.         Click Generate. A random password will be generated.


                    iv.         You can use the email address used to log in to Zoho and this generated password to sign in to Zoho Creator Plug-in for MS Word. You have signed in.

8.     Choose the required application, the required report in the selected application and the required fields in the selected report to insert in your document. For example, Sales Application > Sales ReportQuantity and Price fields. Here Sales Report is a report for Sales Application. Quantity and Price fields are fields in Sales Report.

9.     Select the field values you want to insert in your document and click on Start Merge.
               Screenshot displaying Quantity and Price fields merged with the document 

Note:

o   Save the document before clicking on Start Merge to save the document as a template, for reusability purpose. 

o   Checking Merge in separate documents will create a new document for each selected record.

10.  Select the record(s) you want to merge with your document in the po-pup.

11.  Click on Merge. For example, values for Quantity and Price fields will be imported into the document, from the selected record as shown below.

12.  The following screenshot shows the newly created mail merge document with values stored in Zoho Creator.
        Screenshot displaying imported field values in the mail merge document.

Note:

o   You can use the search box in the Merge records popup window to search for required records and insert them.

o   For each selected record, a new page gets created in the same document with the selected field values. For example, if we select 2 number of records, it will create 2 pages with values of each record in each page.

Limitations

1.    While searching for numeric records in Merge Records pop-up window, please provide the full and exact numeric value to yield search results. For string values, you can simply search using the first few letters.

2.     Once you click on Merge in Merge Records pop-up window, your document will get imported with the selected values. But the task pane on the right will disappear and wont re-appear until you create a new mail merge document or open a saved document.

 


    • Related Articles

    • Exporting Data in LTS CRM

      Exporting CRM Data Zoho CRM allows you to export and take a backup of all your CRM data in a few simple steps. The different export options available are to export data or to request a CRM data backup.  Export Module Data The Export Data feature ...
    • Using Mail Merge with LTS CRM

      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 ...