Editing SQL Text Fields
You can use the Mail Merge Field Editor to edit new and existing SQL Text merge fields. When you select an SQL Text 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.
- Format Type - Allows you to change the type of formatting applied to the selected
- merge field.
- Format String - Allows you to format the value as it displays in the merge field. You must set the Format Type before adding a format string. String formats depend on the format type you select.
- Text Before - Allows you to enter text that will appear before the selected merge field.
- Text After - Allows you to enter text that will appear after the selected merge field.
- Special Format - Allows you to apply special character formatting to the merge field (including text before and text after a merge field).
- Hyperlink Address - Allows you to enter a URL to be opened from the merge field.
Hyperlink Address Examples
- 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.
