Hello everybody!
Can I make e-mail message by xp_sendmail SP in HTML (without attach)?
Thanks.
Printable View
Hello everybody!
Can I make e-mail message by xp_sendmail SP in HTML (without attach)?
Thanks.
use xp_sendmail and sp_makewebtask.
------------
Michael at 8/29/00 8:12:01 AM
Hello everybody!
Can I make e-mail message by xp_sendmail SP in HTML (without attach)?
Thanks.
Chris,
Thanks for answer, but I need query result into message body (in HTML). By you way I can get HTML page or reference to it. I can make HTML-page by multiple SELECT and make attach file with *.html extention. It's one way, but not need it. I need all of that into message body. May be @type argument but I can't find docs or examples.
Regards, Michael.
------------
chris at 8/30/00 5:28:26 PM
use xp_sendmail and sp_makewebtask.
------------
Michael at 8/29/00 8:12:01 AM
Hello everybody!
Can I make e-mail message by xp_sendmail SP in HTML (without attach)?
Thanks.
Why don't you use dynamic SQL and build the HTML dynamically. If you always have a static body, just with dynamic values, that would be your best bet.
------------
Michael at 8/31/00 3:12:24 AM
Chris,
Thanks for answer, but I need query result into message body (in HTML). By you way I can get HTML page or reference to it. I can make HTML-page by multiple SELECT and make attach file with *.html extention. It's one way, but not need it. I need all of that into message body. May be @type argument but I can't find docs or examples.
Regards, Michael.
------------
chris at 8/30/00 5:28:26 PM
use xp_sendmail and sp_makewebtask.
------------
Michael at 8/29/00 8:12:01 AM
Hello everybody!
Can I make e-mail message by xp_sendmail SP in HTML (without attach)?
Thanks.
By task conditions, I must make D-SQL in HTML. Yes, you way is good, but it some harder for administration (many stages).
1.Sheduled task for generate static page.
2.Shedule task for send e-mail messages.
(This stages must be coordinated by time.)
I'm already make D-SQL & HTML from file-attach. But I want to know, can I send HTML message by xp_sendmail or not. :)
Thanks again.
Michael
------------
Chris at 8/31/00 10:57:37 AM
Why don't you use dynamic SQL and build the HTML dynamically. If you always have a static body, just with dynamic values, that would be your best bet.
------------
Michael at 8/31/00 3:12:24 AM
Chris,
Thanks for answer, but I need query result into message body (in HTML). By you way I can get HTML page or reference to it. I can make HTML-page by multiple SELECT and make attach file with *.html extention. It's one way, but not need it. I need all of that into message body. May be @type argument but I can't find docs or examples.
Regards, Michael.
------------
chris at 8/30/00 5:28:26 PM
use xp_sendmail and sp_makewebtask.
------------
Michael at 8/29/00 8:12:01 AM
Hello everybody!
Can I make e-mail message by xp_sendmail SP in HTML (without attach)?
Thanks.