Editing SQL Image fields in Word templates

You can use the Mail Merge Field Editor to edit new and existing Infor CRM SLX Image merge fields. When you select an Image field from the list view, the edit options are displayed in the edit pane. The image field you want to reference in the SQL query must already exist as a BLOB field in the Infor CRM SLX database.

There are also some image fields listed under entities in Insert Field menu. For example, point to Contact, and then click ContactImage, or point to Account and then click AccountImage. To edit those images, follow the instructions for editing a Regular Infor CRM SLX field in the help topic. For more information, see Editing Merge Fields in a Word Template.

Note:

This feature is available only in Microsoft Word after installing Infor CRM SLX Mail Merge for Microsoft Word. For steps see Installing Infor CRM SLX Mail Merge For Microsoft Word.
You cannot access this feature in Infor CRM SLX Web Client.

To edit an Infor CRM SLX image field:

Perform one of these actions in Microsoft Word:
- Select the Infor CRM Image field in Infor CRM template. On the Mailings tab click Edit Fields to edit an existing image in an Infor CRM SLX mail merge template.
- Click Insert Field and then click Image on the Mailings tab to add an image to an Infor CRM SLX mail merge template.
Edit or specify this information:

Field Identifier

The text that is displayed in the template.

SQL

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 Value Fields in Word Templates.
The sample SQL query provides the appropriate format for inserting an image. If necessary, change the query to point to the image field and table and define the WHERE statement to select the record’s image.
For example, SELECT CONTACTIMAGEFROM CONTACT WHERE CONTACTID = :ContactID

Format Type

If Image is not already selected, click the drop-down arrow and select Image.

Image blob data

The image is stored as a blob field in the database. You must also select an image type from the list. The image type is used to create a temporary file name with the file type extension.

Specify image size

Select this check box to specify the image size. In the Width and Height fields, you can specify width and height of the image in inches.
Specify width and height of the image in inches. The default values are 1.00 inch by 1.00 inch.
Note: To use the size specified in the database, clear this option.
Click OK.