Modifying Merge fields in a Word template

You can use the Mail Merge Field Editor screen to modify the new and existing merge fields. You can view the template merge fields in the list pane and the edit options in the edit pane. You can also click Remove From Template on the toolbar to remove the merge fields from the template.

Note: This feature is available in Microsoft Word only after installing Infor CRM SLX Mail Merge for Microsoft Word and cannot be accessed from the Infor CRM SLX Web Client. It is available in Microsoft Word only after installing Infor CRM SLX Mail Merge For Microsoft Word. See Installing Infor CRM SLX Mail Merge for Microsoft Word.

To modify merge fields:

  • Access the Infor CRM template in Microsoft Word.
  • Click Edit Fields on the Mailings tab.
    Note: To modify merge fields you can:
    • Right-click an Infor CRM SLX merge field in the document, and click Infor CRM SLX Template Field Properties.
    • Click Insert Field on the Mailings tab and select one of these values:
      • SQL Value
      • Table
      • List
      • Image
    • Opportunity Product Table: The Infor CRM SLX Mail Merge Field Editor window is displayed and the template merge fields are displayed in the list view. These columns are displayed in the list view:
      • Field: The name of the merge field as displayed in the template.
      • Type: The merge field type.
  • Highlight the merge field you require to modify in the list pane.

    Based on the merge field type, different modify options are displayed:

    • SQL Value. See Modifying SQL value fields in Word templates
    • Table. See Modifying SQL tables in Word templates
    • List. See Editing SQL lists in Word templates
    • Image. See Modifying SQL Image fields in Word templates
    • Opportunity Product Table. See Modifying SQL tables in Word templates
    • Infor CRM SLX field:
      Field Identifier
      Specifies the table and display name that identify the merge field. You can only change the display name.
      Format Type
      Specifies the format applied to the selected merge field, such as fixed, integer, percent, or currency. Possible values:
      • Date fields and the Mail Merge Date Stamp default to Date or Time.
      • Date fields Format String defaults to the system short date format.
      • Mail Merge Date Stamp fields Format String defaults to the system short date and short time format.
      Format String
      Specifies the format applied to the value displayed in the merge field. You must set the format type before adding a format string. The available string formats depend on the selected format type.
      Text Before
      Specifies the text displayed before the selected merge field.
      Text After
      Specifies the text displayed after the selected merge field.
      Special Format
      Specifies the special character formatting applied to the merge field and any text before or after the field.
      Table
      The table associated with the database field. If the database field is the result of a join, the caption for this option reads Main Table.
      Field
      The database field. If the database field is the result of a join, the caption for this option reads Key Field.
      Calculated
      Indicates whether the field contains a calculated value.
      Join
      Indicates whether the field results from a database join.
      Link Style
      To define a merge field as a link, click the arrow and select the type of link. Options include: Email, Telephone, HTTPS, HTTP, FTP, and as-is. Example: To insert a link of the form https://mysite.com/dashboard.aspx?contactid=<contactid>&view=details
      1. On the Mailings tab, Insert Field menu, point to Contact, and scroll to and click the Id field.
      2. Click Edit Fields.
      3. Select CONTACT.Id in the left pane if required and set these options:
        • Text Before: [https://mysite.com/dashboard.aspx?contactid=]

          Replace the suggested URL with your own URL

        • Text After: &view=details
        • Link style: HTTPS
        • Link Display Text: Specify the text for the link that must display in the merged document. For example, view in Infor CRM SLX
      Hide entire paragraph if field does not contain data
      If this check box is selected, the extra spaces are removed when a field is blank.
      Preserve Character Formatting
      If this check box is selected, character formatting is preserved during a merge.
      When field is populated, move to the next record
      If this check box is selected, the next record is used to populate subsequent fields. This option is useful for address labels or tables that list multiple records. For example, for address labels, select this option for the last address field.
      Signature
      A list of available email signatures. <Default Signature> is the default value.
      Note: This option is available only if the selected field is Signature.
  • Click OK.
  • Click Save to save your changes, or click Save as New Template on the Mailings tab.