I am trying to send an email with Data-Driven Data. In my SQL I am creating the Message Comment to include in the email and I am including an HTML formatted link in the message. When I choose to send the email using the TEXT format the email includes the message but does not format the HTML correctly:
If I choose to send the message with HTML or HTML (Basic) then SQL-RD reads the comment as <[r]MSG_COMMENT> and sends this instead of the message content.
Is it possible to build the message content in SQL and have SQL-RD format the HTML?