cdosysmail with attachment

With cdosysmail I have gotten my code to work to programatically send emails
out as HTML.
Does anyone know how to tweak the standard CDO example to send the query
results as an attachment?
thanksI strongly, strongly, strongly urge you to use xp_smtp_sendmail instead of
cdo. See http://www.aspfaq.com/2403 (which incidentally does have a sample
of using CDO to send an attachment, but please read my first sentence
again).
A
"26point2er" <26point2er@.discussions.microsoft.com> wrote in message
news:D8D7CBB4-2174-4F79-B94D-18520BC6B060@.microsoft.com...
> With cdosysmail I have gotten my code to work to programatically send
> emails
> out as HTML.
> Does anyone know how to tweak the standard CDO example to send the query
> results as an attachment?
> thanks
>|||Thank you for the input. I will post my results here.
"Aaron Bertrand [SQL Server MVP]" wrote:

> I strongly, strongly, strongly urge you to use xp_smtp_sendmail instead of
> cdo. See http://www.aspfaq.com/2403 (which incidentally does have a sampl
e
> of using CDO to send an attachment, but please read my first sentence
> again).
> A
>
>
> "26point2er" <26point2er@.discussions.microsoft.com> wrote in message
> news:D8D7CBB4-2174-4F79-B94D-18520BC6B060@.microsoft.com...
>
>

CDONTS on sql2000 ?

I need to send email in html format, but xp_sendmail
doesnot support it.
Does anyone know hot to use cdonts on sql2000 ?
Thx.On Tue, 4 Nov 2003 16:59:28 -0800, "Kresna Rudy Kurniawan"
<kresna_rk@.yahoo.com> wrote:
>I need to send email in html format, but xp_sendmail
>doesnot support it.
>Does anyone know hot to use cdonts on sql2000 ?
Instead of CDONTS, use CDOSYS on Windows 2000.
http://msdn.microsoft.com/library/en-us/dnanchor/html/collabdataobjects.asp
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander|||> Does anyone know hot to use cdonts on sql2000 ?
CDONTS is deprecated.
Use CDO.Message or, better yet, xp_smtp_sendmail.
http://www.aspfaq.com/2403|||You can use XPSMTP instead, see http://SQLDev.Net/xp/xpsmtp.htm
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.
"Kresna Rudy Kurniawan" <kresna_rk@.yahoo.com> wrote in message
news:05c201c3a338$109174d0$a401280a@.phx.gbl...
> I need to send email in html format, but xp_sendmail
> doesnot support it.
> Does anyone know hot to use cdonts on sql2000 ?
> Thx.