I am using TSQL to dynamically construct an html email for our customers. I need to retrieve and insert a signature (stored jpeg image in sql server table) into a section of the email. The signature will vary, depending on who the customer service rep is for the customer.
I can determine which signature to pull from the database, but am not sure how I can include it in the html of the email.
Any suggestions as to how to do this?