Code Groups

CREATE Procedure sn_SMTPMail
AS

EXEC @resultcode = sp_OACreate ‘CDONTS.NewMail’, @oMail OUT
if @resultcode = 0
BEGINEXEC @resultcode = sp_OACreate ‘CDONTS.NewMail’, @oMail OUTEXEC @resultcode = sp_OASetProperty @oMail, ‘From’, ‘youremail@domain.com’
EXEC @resultcode = sp_OASetProperty @oMail, ‘To’, ‘youremail@domain.com’
—EXEC @resultcode = sp_OASetProperty @oMail, ‘HTMLBody’, 0
EXEC @resultcode = sp_OASetProperty @oMail, ‘Subject’, ‘Mail subject’
EXEC @resultcode = sp_OASetProperty @oMail, ‘Body’, ‘Boy Test’
EXEC @resultcode = sp_OAMethod @oMail, ‘Send’, NULLEXEC sp_OADestroy @oMail

ENDSET nocount off
GO

See more progress on: code groups

Share This