"Rudolf Henning" <Rudo...@Hotmail.com> wrote in message

> 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)?

> thanks

> Rudolf Henning

> 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" <Rudo...@Hotmail.com> wrote in message
> news:OPw6Lfl8AHA.1992@tkmsftngp02...
> > 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)?

> > thanks

> > Rudolf Henning