|
Eyespi20
Starting Member
USA
10 Posts |
 Posted - 05/21/2012 : 15:33:14
|
I have a trigger that fires based on customers to send them information. Some of my customers can receive HTML formatted email and some cannot. When I can, I like to send "pretty" emails with our company logo, etc, but for those customers who cannot receive HTML emails, I want to send them plain text emails. I've coded my trigger to separate these customers out and have a parameter @bf where I set the body format to 'TEXT' or 'HTML' as appropriate, however when I try to set the @Body_Format parameter in the sp_send_dbmail, it makes the HTML text regardless. I've checked the parameter and it does return HTML and TEXT for the appropriate customer, but the stored procedure simply ignores the parameter and sends everything plain text.
Can you not set this to a variable? I seem to be able to set all the other settings to a parameter successfully.
Margaret
è¿é |
|
setting body_format in SP_SEND_DBMAIL
