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.

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 an 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. 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 PICTURE FROM CONTACT WHERE CONTACTID = :ContactID
Specify this information
- 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.
Click OK.