Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  need help on sending email from a sp

Author  Topic  didio Starting Member 7 Posts Posted - 2001-03-07 : 05:07:35 Hi, I want to execute this t-sql command but its not working, what I want to do here is the following: I open the cdo for windows 2000 object to send emails from a stored procedure. I want to set the property 'textbody' with a query. exec @hr = sp_OASetProperty @CDO, 'TextBody', (select Message from tblMailings where MailingID = @MailingID) anyone? Marcel Vogel.