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}