Installation[-][- -][++]

EXEC sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'
 

DECLARE @rc INT
EXEC @rc = master.dbo.xp_smtp_sendmail
    @FROM       = N'from@email.com',
    @FROM_NAME  = N'fromname',
    @replyto    = N'replyto@email.com',
    @TO         = N'to@email.com',
    @subject    = N'Your Subject Here',
    @TYPE       = N'text/html', 
    @message    = N'<b>Your</b> HTML body here',
    @timeout    = 10000,
    @server     = N'Your SMTP Server Here'
SELECT RC = @rc