Create a Dynamic Link in a Message Body

Create a dynamic link in a message body.

Procedure

  1. Navigate to the Sequence database.
  2. Create the following stored procedure.
    CREATE PROCEDURE sp_{StoredProcedureName} AS SELECT '<a href="{link}" target="_blank">{TEXT}/<a'> AS link
  3. In the message body, insert the following expression.
    Link to {SQL: exec sp_StoredProcedureName}
About this Article
  • Created: 07/11/2017 2:16 am EDT
  • Last updated: 07/11/2017 10:29 am EDT
In This Article