Modifying SQL Image fields in Word templates

You can use the Mail Merge Field Editor to modify new and existing application 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 require to reference in the SQL query must already exist as a BLOB field in the application 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 Account Image. To modify those images, follow the instructions for modifying a Regular application field in the help topic. For more information, see Modifying Merge fields in a word template

Note:

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

To modify an application 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 modify an existing image in an application mail merge template.
- Click Insert Field and then click Image on the Mailings tab to add an image to an application mail merge template.
Modify or specify this information:

Field Identifier

The text that is displayed in the template.

SQL

In the field, specify the SQL query, or click the Ellipsis menu to access the Edit SQL window to insert parameters or execute SQL to test the statement. For more information, see Modifying SQL value fields in Word templates.
The sample SQL query provides the appropriate format for inserting an image. If required, change the query to point to the image field and table and define the WHERE statement to select the record image.
For example, SELECT CONTACTIMAGEFROM CONTACT WHERE CONTACTID = :ContactID

Format Type

If Image is not already selected, click the 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.