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 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 on the Mailings tab.Note: To modify merge fields you can:
- Right-click an Infor CRM SLX merge field in the document, and click .
- Click 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
- On the Mailings tab, menu, point to , and scroll to and click the Id field.
- Click .
- Select in the left pane if required
and set these options:
- :
[https://mysite.com/dashboard.aspx?contactid=]
Replace the suggested URL with your own URL
- : &view=details
- : HTTPS
- : Specify the text for the link that must display in the merged document. For example, view in Infor CRM SLX
- :
[https://mysite.com/dashboard.aspx?contactid=]
- 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 .
- Click to save your changes, or click on the Mailings tab.