Editing SQL Image Fields
You can use the Mail Merge Field Editor to edit new and existing SQL Image merge fields. When you select an SQL Image field from the list view, the edit options will display in the edit pane.
- Field Identifier - Allows you to change the text that appears in the template.
- SQL - Allows you to enter a SELECT statement to request data from the OLE DB provider. Only the first record of the first column will display.
Click on the Edit button to open the Edit SQL dialog box. - Format As - Displays the merge field type.
- Query Returns - Allows you to select how the image is stored. You can choose from:
- Image blob data
The image is stored as a blob field in the database. You must also select an image type from the drop-down list. The image type is used to create a temporary file name with the file type extension.
- Fully-qualified path and file name of an image
Use this option if the record returned by the SQL query contains a fully-qualified path and name of an image.
If the image begins with HTTP, it will be inserted as a hyperlink to that file; otherwise a copy of the image will be stored with the document.
- Hyperlink Address - Allows you to enter a URL to be opened from the merge field.
- Hyperlink Target - Allows you to choose how the URL will be opened. From the drop-down list, select a Target.
- Hyperlink Screen Tip - Allows you to enter text that appears when the mouse pointer is positioned over the hyperlink.
Parameters can be included in the Hyperlink Address and Hyperlink Screen Tip, and can be useful when creating a mailto:hyperlink.
