Hi all,
really frustrating issue, this one.
We've got a SQL server which is sending messages using the XP_sendmail command without any problems....well, other than the fact that, despite the profile within Outlook for the account being used to run SQL being set to send as plain text, any messages sent via xp_sendmail are arriving as htlm text.
If I open Outlook and send an email, it is sent as plain text, and so it appears to be something about the way xp_sendmail issues the command, or the profile it uses, which is causing html to be selected.
basically, does anyone have any ideas how I can stop this? I've not found any parameter for xp_sendmail itself which mentions about the message type, and i've created a new mail profile within Windows for the account, and selected that profile as the one for SQL to use, but still no luck.
Would be mighty grateful to anyone who has any further ideas where i can check/set this.
Many thanks,
Chris
really frustrating issue, this one.
We've got a SQL server which is sending messages using the XP_sendmail command without any problems....well, other than the fact that, despite the profile within Outlook for the account being used to run SQL being set to send as plain text, any messages sent via xp_sendmail are arriving as htlm text.
If I open Outlook and send an email, it is sent as plain text, and so it appears to be something about the way xp_sendmail issues the command, or the profile it uses, which is causing html to be selected.
basically, does anyone have any ideas how I can stop this? I've not found any parameter for xp_sendmail itself which mentions about the message type, and i've created a new mail profile within Windows for the account, and selected that profile as the one for SQL to use, but still no luck.
Would be mighty grateful to anyone who has any further ideas where i can check/set this.
Many thanks,
Chris
