-
xp_sendmail formatting
I am using xp_sendmail to fire off e-mails from asp code when certain events happen (i.e. an insert to a table). My Users would like the e-mail to be nicely formatted with line breaks, bold, colours etc. There is nothing in the xp_sendmail command itself to do this. Is there some way of embedding html commands within the message? But then does the e-mail have to be sent in a certain way for the recepient to get the formatting and not just receive a lot of strange (to them) codes in the message? Or is there any other way of achieving the desired end result?
-
xp_sendmail formatting (reply)
This will send any message as x.html. In the message format it using
HTML tags.
Here is the example
EXEC master..xp_sendmail @recipients = 'mak_999@yahoo.com',
@query ="select '<html><B> Hi Mak. </b> <br> Its a test message.<br><br><hr><B>-Sweetie</b></html>'",
@subject = 'HTML Sample',
@attach_results = 'TRUE', @width = 250,@no_header ='True',
@attachments = "x.html"
------------
steve at 5/22/2002 7:29:33 AM
I am using xp_sendmail to fire off e-mails from asp code when certain events happen (i.e. an insert to a table). My Users would like the e-mail to be nicely formatted with line breaks, bold, colours etc. There is nothing in the xp_sendmail command itself to do this. Is there some way of embedding html commands within the message? But then does the e-mail have to be sent in a certain way for the recepient to get the formatting and not just receive a lot of strange (to them) codes in the message? Or is there any other way of achieving the desired end result?
-
xp_sendmail formatting (reply)
Thanks, MAK. I'll try it out
------------
MAK at 5/22/2002 9:17:58 AM
This will send any message as x.html. In the message format it using
HTML tags.
Here is the example
EXEC master..xp_sendmail @recipients = 'mak_999@yahoo.com',
@query ="select '<html><B> Hi Mak. </b> <br> Its a test message.<br><br><hr><B>-Sweetie</b></html>'",
@subject = 'HTML Sample',
@attach_results = 'TRUE', @width = 250,@no_header ='True',
@attachments = "x.html"
------------
steve at 5/22/2002 7:29:33 AM
I am using xp_sendmail to fire off e-mails from asp code when certain events happen (i.e. an insert to a table). My Users would like the e-mail to be nicely formatted with line breaks, bold, colours etc. There is nothing in the xp_sendmail command itself to do this. Is there some way of embedding html commands within the message? But then does the e-mail have to be sent in a certain way for the recepient to get the formatting and not just receive a lot of strange (to them) codes in the message? Or is there any other way of achieving the desired end result?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|