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 are displayed 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 is displayed.

    Click Edit to open the Edit SQL window.

  • Format As: Displays the merge field type.
  • Query Returns: Allows you to select how the image is stored. The options are:
    • 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 is inserted as a hyperlink to that file. Else, a copy of the image is stored with the document.

  • Hyperlink Address: Allows you to enter a URL to be opened from the merge field.

    Hyperlink address examples:

    • http://www.infor.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 is 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.

    Infor CRM Parameter Description
    SLXAccountManagerEmail The :SLXAccountManagerEmail parameter is replaced with the [account manager]'s email address for the contact record being merged to.
    SLXAccountManagerName The :SLXAccountManagerName parameter is replaced with the [account manager]'s name for the contact record being merged to.
    SLXAccountManagerTitle The :SLXAccountManagerTitle parameter is replaced with the [account manager]'s title for the contact record being merged to.
    SLXAccountManagerPhone The :SLXAccountManagerPhone parameter is replaced with the [account manager]'s phone number for the contact record being merged to.
    SLXAccountManagerFax The :SLXAccountManagerFax parameter is replaced with the [account manager]'s fax number for the contact record being merged to.
    SLXUserEmail The :SLXUserEmail parameter is replaced with the mail merge user's email address.
    SLXUserName The :SLXUserName parameter is replaced with the mail merge user's name.
    SLXUserTitle The :SLXUserTitle parameter is replaced with the mail merge user's title.
    SLXUserPhone The :SLXUserPhone parameter is replaced with the mail merge user's phone number.
    SLXUserFax The :SLXUserFax parameter is replaced with the mail merge user's fax number
Related topics