|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Output query to emailMight try using sp_makewebtask with xp_sendmail.
HTH Jerry Show quote "J1C" <just1co***@yahoo.ca> wrote in message news:1129845601.040046.207820@g44g2000cwa.googlegroups.com... > I'm using a custom stored proc. to send email too ... > CDO?
See: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncdsys/html/cdo_roadmap.asp Google for more if needed. HTH Jerry Show quote "J1C" <just1co***@yahoo.ca> wrote in message news:1129852154.020760.101680@f14g2000cwb.googlegroups.com... > No MAPI. Can't use xp_sendmail. > Try xp_smtp_sendmail from www.sqldev.net.
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "J1C" <just1co***@yahoo.ca> wrote in message news:1129852154.020760.101680@f14g2000cwb.googlegroups.com... > No MAPI. Can't use xp_sendmail. > I'm not having trouble sending email - I'm using CDO. The problem is
building the query to output the resultset to HTML and passed as the @body for the email.  |
|||||||||||||||||||||||
Other interesting topics