Editing Merge Fields in a Word Template

You can use the Mail Merge Field Editor page to edit 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 accesed from the Infor CRM SLX Web Client. It is available in Microsoft Word only after Installing Infor CRM SLX Mail Merge For Microsoft Word.

To edit merge fields:

  1. Open an Infor CRM template in Microsoft Word.
  2. Perform one of these actions:
    • Click Edit Fields on the Mailings tab.
    • 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
      • Mail Merge Date Stamp
      • 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. Possible values:
        • Regular
        • Outlook Signature
        • Opportunity Product Table
        • SQL
        • Custom
  3. Highlight the merge field you want to edit in the list pane.

    Depending on the merge field type, different edit options are displayed.

    • SQL Value. See Editing SQL Value Fields in Word Templates
    • Table. See Editing SQL Tables in Word Templates
    • List. See Editing SQL Lists in Word Templates
    • Image. See Editing SQL Image fields in Word templates
    • Opportunity Product Table. See Editing SQL Tables in Word Templates
    • Infor CRM SLX field:
      Field Identifier
      Allows you to change the text that appears in the template. The Field Identifier for a Regular mail merge field consists of the table and the display name. You can only change the display name.
      Format Type
      Allows you to change the type of formatting that is applied to the selected merge field. For example, fixed, integer, percent, or currency.
      • Date fields and the Mail Merge Date Stamp default to Date/Time.
      • Date fields Format String defaults to your system short date format.
      • Mail Merge Date Stamp fields Format String defaults to your system short date and short time format.
      Format String
      Allows you to format the value displayed in merge field. You must set the format type before adding a format string. Valid string formats depend on the format type you select.
      Text Before
      Allows you to enter text that appears before the selected merge field.
      Text After
      Allows you to enter text that appears after the selected merge field.
      Special Format
      Allows you to apply special character formatting to the merge field (including text that appears before and after a merge field).
      Table
      Displays the table associated with the database field. If the database field is the result of a join, then the caption for this option reads "Main Table".
      Field
      Displays the database field. If the database field is the result of a join, then the caption for this option reads "Key Field".
      Calculated
      Displays whether or not the field is a calculated value.
      Join
      Displays whether or not the field is the result of a database join.
      Preserve Character Formatting
      Allows you to preserve character formatting during a merge.
      Link Style
      To define a merge field as a link, click the drop-down 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 then scroll to and click the Id field.
      2. Click Edit Fields.
      3. Select CONTACT.Id in the left pane if necessary and set the following 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 Type the text for the link that must display in the merged document. For example, “view in Infor CRM SLX.
      Link Display Text
      In the Link Display Text box, type the text for the link that must display in the merged document. For example, “contact us” for an email link.
      Signature
      Displays a drop-down list of available email signatures. <Default Signature> is the default value.
    • Mail Merge Date Stamp: Some options have been set for you:
      Field Identifier
      Allows you to change the text that appears in the template.
      SQL
      The SQL statement defaults to SELECT SLXGETDATE(LOCALTIME) which inserts the local system date and time. To edit the SQL query, in the box, type the SQL query, or click the ellipsis button to open the Edit SQL window to insert parameters or execute SQL to test the statement. For more information, see Editing SQL in a Word Template SQL Merge Field.
      Format Type
      Allows you to change the type of formatting that is applied to the selected merge field. For example, fixed, integer, percent, or currency.

      Defaults to Date/Time

      Format String
      Allows you to format the value displayed in merge field. You must set the format type before adding a format string. Valid string formats depend on the format type you select.

      Format Type defaults to Date/Time and Format Type defaults to your system short date and short time format

      Text Before
      Allows you to enter text that appears before the selected merge field.
      Text After
      Allows you to enter text that appears after the selected merge field.
      Special Format
      Allows you to apply special character formatting to the merge field.
      Link Style
      To define a merge field as a link, click the drop-down 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

      Link Display Text
      In the Link Display Text box, type the text for the link that must display in the merged document. For example, “contact us” for an email link.
  4. Click OK after making your edits.
  5. Click the Save button to save your changes, or on the Mailings tab, click Save as New Template.

For more information, see Editing SQL Image Fields in Word Templates