SugarCRM SupportProduct GuidesPlug-insMS Word Plug-inMS Word Plug-in User Guide

MS Word Plug-in User Guide

Overview

This document describes how to use the Sugar Plug-in for Microsoft Word to merge data such as names and addresses from Sugar with form letter templates created in Microsoft Word.

For installation instructions, please refer to the Word Plug-in Installation Guide. For a complete list of platform requirements and supported environments, please refer to the Plug-ins Supported Platforms page.

Note: If SAML authentication is enabled in the Sugar application, Sugar Plug-in for MS Word cannot connect to Sugar.

Functionality

You can perform the following actions using the Sugar Plug-in for Microsoft Word:

  • Mail merge from Sugar using an MS Word template or mail merge from MS Word using Sugar data
  • Include an unlimited number of records such as accounts, contacts, and opportunities within a single merge operation
  • Save the merged documents as Sugar documents

Mail Merge functionality is available for the following modules:

  • Accounts
  • Opportunities
  • Leads
  • Contacts
  • Cases
  • Campaigns

Note: Mail merge cannot be performed directly in the Sugar application for Sugar versions 7.x and above.

User Roles

To be able to use the plug-in, users are required to have the ability to export records in Sugar. Any Sugar user with a role that prevents export as seen in Admin > User Management > {User's Name} > Access will not be able to utilize the Sugar Plug-in for MS Word.

Mail Merge Templates

You can create mail merge templates in MS Word and upload them to Sugar. Templates are stored in the Documents module. When you create a template, you have to specify the primary module from which you creating the template.

Note: The mail merge functionality in the application is not supported in Sugar 7.x and above.

Depending on the primary module that you select, you can also select fields from a related module. For example, if you are creating a template from the Accounts module, you can select fields from Contacts or Opportunities. The table below lists the related modules, if any, for modules supported by the Sugar Plug-in for Microsoft Word.

Primary Module Related Module
Accounts Contacts, Opportunities
Campaign Targets None
Cases Contacts
Leads None
Opportunities Contacts, Accounts

Creating Mail Merge Templates

  1. From the SugarCRM drop-down menu in MS Word, select Define Template. This displays the Select Master Module dialog box. Existing record fields from the selected module display in the Add Fields dialog box.
  2. Select the fields that you want to add to the template and click Add to Document.
    Note: When using checkbox fields on a merge template, the values "1" and "0" will be shown where "1" indicates the record's box is checked and "0" indicates it is not. You may create a formula to convert the "1" and "0" to words of your choosing using these instructions.
  3. If related module fields are available to select, the Next button will display in the Add fields from dialog box. If no related module fields are available to select, the Finish button will display in the Add fields from dialog box. If you click Next, you can select fields from a related module and click Add to Document. The selected fields from the related modules are added to the template.
  4. Click Finish.
  5. To move a field, highlight it and drag it to the new location; you can also enter other text in the template.
  6. Select Upload Document from the SugarCRM menu. This displays the Upload Document to SugarCRM dialog box.
  7. Enter a name and a revision number for the document and click OK. The Is Mail Merge Template checkbox is selected by default to ensure that it displays as a template in the Documents module. If the operation is successful, a message displays stating that the template was uploaded successfully.
  8. Click OK. This displays the template in the List View of the Documents module.

Updating Mail Merge Templates

You can view and update mail merge templates from Sugar using the following steps:

  1. Select the template from the List View of the Documents module.
  2. Select the document from the Document Revisions sub-panel in the Document's Detail View.
  3. Select the template from the Document Revision page and open it in MS Word.
  4. To update the document, make the necessary changes in MS Word, and upload the template to Sugar.

Performing a Mail Merge

You can perform a mail merge operation from Sugar or from Sugar Plug-in for Microsoft Word. To perform a mail merge in Sugar, define the template in MS Word, upload it into Sugar, select one or more records from the selected module, and merge them with the template.

Note: Mail merge cannot be performed directly in the Sugar application for Sugar versions 7.x and above.

To perform a mail merge operation in MS Word, define the template in MS Word and then merge it with one or more records from the selected module.

When you upload a template from MS Word, it displays in the Document module as a mail merge template. The Shortcuts menu displays a Mail Merge option that allows you to access the Sugar Mail Merge wizard without navigating to the module's home page.

Note: The Mail Merge option must be enabled on both the Administration page and the User Preferences page to display the Mail Merge option.

Performing a Mail Merge From Sugar

  1. In Sugar, navigate to the appropriate module's home page.
  2. Select the record that you want to merge, and click Mail Merge. The Merge Records page displays the selected module. You can choose a different module from the Selected Module drop-down list
  3. Select an available template from the Select Template drop-down list.
  4. Click Next. The Refine List of Accounts to Merge page displays the selected records.
  5. If you did not select any records, click Search to view existing records from the selected module in the Available list.
  6. Use the left and right arrow to add or remove records. From the drop-down list below, you can choose another related record such as a contact or opportunity
  7. Click Next. Associated records are display If you chose a related module. You can click Select to choose a different associated record. The Review and Complete page is displayed if you did not choose a related module.
  8. Click Next. The Review and Complete page displays the selected module, records, and template.
  9. Click "Begin Merge" to start merging the data with the template; to change a setting, click the Back button. This displays a dialog box requesting you to specify whether to open the merged document in MS Word, or save it to a disk.
  10. Make your selection and click "OK".
    • If you choose to open it in MS Word, the merged document displays on the screen. You can save this document to your local machine or you can upload it into Sugar as a Sugar document.
    • If you choose to save it to a disk, the document is saved to the Temp folder on your local machine.
  11. To begin a new mail merge operation, select "Click Here to Continue".

Note: Mail merge cannot be performed directly in the Sugar application for Sugar versions 7.x and above.

Performing a Mail Merge From MS Word

  1. Open the template in MS Word.
  2. Select Begin Mail Merge from the Sugar menu. This displays a list of available records for the selected module in the Selection window.
  3. Use the right arrow to move records that you want from the Available records list to the Selected Recipients list. A list of records for the selected module displays in the Selection window.
  4. Use the right arrow to move the desired records to the Selected list.
  5. Click Next. Depending on the module that you chose, related records display in the dialog box. For example, for the Accounts module, select an account from the Recipients list to view the related contacts in the Associated Contacts list. For Campaigns, choose the Campaign in the Select Campaign tab and then specify the Targets in the Select Targets tab.
  6. Select a related record if needed.
  7. Click Next. The Complete Mail Merge dialog box displays the selected records.
  8. Click Complete Merge. This displays the merged document.
  9. Select Upload from the SugarCRM menu to upload it to Sugar.
  10. Enter a name for the document, and a revision number; to create notes, select the Create Note option.
  11. Click OK.

If the upload is successful, a message displays confirming it and the document displays as a Sugar record in the Documents module.

 

Last modified: 2020-01-23 15:37:04