Editing SQL Lists in Word Templates

You can use the Mail Merge Field Editor to edit new and existing Infor CRM SLX List merge fields. When you select a List merge field from the list pane view, the edit options are displayed in the edit pane. A merge field list with merged content as defined in the SQL query.

Note: This option is available only in Microsoft Word after installing Infor CRM SLX Mail Merge for Microsoft Word. For more information, see Installing Infor CRM SLX Mail Merge For Microsoft Word.

The option is not available in the Infor CRM SLX Web Client.

To edit an Infor CRM SLX list field

In Microsoft Word, open an Infor CRM SLX template.
Do one of the following:
- On the Mailings tab, Click Edit Fields.
- On the Mailings tab, Click Insert Field and select List.
Edit or specify this information

Field Identifier

The text that is displayed in the template.

SQL

Click the ellipsis button to open the Edit SQL window to create and edit SQL statements for mail merge fields, insert parameters into a SQL statement and test the SQL.
The sample SQL query provides the appropriate format for inserting a list. Change the query to list the (SELECT) field(s) to include required item for each list item, type the (FROM) table that contains those fields, and then define the (WHERE) statement to identify which records to list.
SELECT NAMEPFL FROM CONTACT WHERE ACCOUNTID = :AccountID
Note: You must separate multiple SELECT items with commas (,).

List Format

Select the required type of list. The bullets and numbered are the possible options with various format types.

Bullet character

If the List Format is Bullet, the Bullet character option is available. Click the drop-down arrow and select the desired bullet style.
Click OK.