DECLARE @From varchar(100)
DECLARE @To varchar(100)

DECLARE @Subject varchar(100)
DECLARE @Body varchar(4000)

DECLARE @CC varchar(100) 
DECLARE @BCC varchar(100) 

SET @CC  = Null
SET @BCC = Null

DECLARE @MailID int
DECLARE @hr int

SET @From = 'jblow@.com'
SET @To = 'jblow@.com'

SET @Subject = 'Testing'

SET @Body = 'Testing'

EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT
EXEC @hr = sp_OASetProperty @MailID, 'From',@From
EXEC @hr = sp_OASetProperty @MailID, 'Body', @Body
EXEC @hr = sp_OASetProperty @MailID, 'BCC',@BCC
EXEC @hr = sp_OASetProperty @MailID, 'CC', @CC
EXEC @hr = sp_OASetProperty @MailID, 'Subject', @Subject
EXEC @hr = sp_OASetProperty @MailID, 'To', @To
EXEC @hr = sp_OAMethod @MailID, 'Send', NULL
EXEC @hr = sp_OADestroy @MailID