Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL mail and html format
0 views
Skip to first unread message
Rudolf Henning
Jun 11, 2001, 5:21:27 AM6/11/01
to
We have a situation where we want to output some data in a properly
formatted way like html but sql mail does not seem to support it. We tried
using things like sp_makewebtask but this require dbo permissions which we
cannot make use of.
The only feasable way seems to create the html file outside sql and specify
it as the attachment of a xp_sendmail sp call but this means you must make
use of another cleanup mechanism etc.
Is there someone else who had the requirement to want to send HTML formatted
mail messages using sql mail (and found a solution to it)?
formatted way like html but sql mail does not seem to support it. We tried
using things like sp_makewebtask but this require dbo permissions which we
cannot make use of.
The only feasable way seems to create the html file outside sql and specify
it as the attachment of a xp_sendmail sp call but this means you must make
use of another cleanup mechanism etc.
Is there someone else who had the requirement to want to send HTML formatted
mail messages using sql mail (and found a solution to it)?
thanks
Rudolf Henning
Tibor Karaszi
Jun 11, 2001, 6:30:29 AM6/11/01
to
Rudolf,
You can't tag the email as HTML'd using xp_sendmail. There exist 3:rd party xp_'s
which support this, also you can use the CDONTS object.
--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
"Rudolf Henning" <Rud...@Hotmail.com> wrote in message
news:OPw6Lfl8AHA.1992@tkmsftngp02...
Rudolf Henning
Jun 11, 2001, 6:44:38 AM6/11/01
to
thanks
"Tibor Karaszi" <tibor.please_reply_to...@cornerstone.se>
wrote in message news:uY71GGm8AHA.1528@tkmsftngp05...
0 new messages