Open topic with Search, TOC, and Index

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; otherwisea 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 Address Examples

• http://www.saleslogix.com/
• mailto:jabbott@abbott.demo?Subject=Special Offer&Body=Yes, please send me info on this special offer!
• mailto::SLXUserName <:SLXUserEmail>?Subject=Special Offer&Body=Yes, please send me info on this special offer!
• ftp://ftp.winzip.com/winzip81.exe
• news://msnews.microsoft.com/microsoft.public.word.mailmerge.fields

• Hyperlink Target - Allows you to choose how the URL will be opened. From the drop-down list, select a Target.
  

Target Option	Description
Page Default (none)	Opens the link in the same window.
Same Frame	Opens the link in the same frame. Corresponds to the HTML target of "_self".
Whole Page	Opens the link into the full body of the current window. Corresponds to the HTML target of "_top".
New Window	Opens the link in a new, unnamed window. Corresponds to the HTML target of "_blank".
Parent Frame	Opens the link in the immediate parent window of the document with the link. Corresponds to the HTML target of "_parent".

• 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.
  

Sage SalesLogix Parameter	Description
SLXAccountManagerEmail	The :SLXAccountManagerEmail parameter will be replaced with the account manager's e-mail address for the contact record being merged to.
SLXAccountManagerName	The :SLXAccountManagerName parameter will be replaced with the account manager's name for the contact record being merged to.
SLXAccountManagerTitle	The :SLXAccountManagerTitle parameter will be replaced with the account manager's title for the contact record being merged to.
SLXAccountManagerPhone	The :SLXAccountManagerPhone parameter will be replaced with the account manager's phone number for the contact record being merged to.
SLXAccountManagerFax	The :SLXAccountManagerFax parameter will be replaced with the account manager's fax number for the contact record being merged to.
SLXUserEmail	The :SLXUserEmail parameter will be replaced with the mail merge user's e-mail address.
SLXUserName	The :SLXUserName parameter will be replaced with the mail merge user's name.
SLXUserTitle	The :SLXUserTitle parameter will be replaced with the mail merge user's title.
SLXUserPhone	The :SLXUserPhone parameter will be replaced with the mail merge user's phone number.
SLXUserFax	The :SLXUserFax parameter will be replaced with the mail merge user's fax number

Related Topics

Editing Merge Fields