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'Your HTML body here',
@timeout = 10000,
@server = N'Your SMTP Server Here'
SELECT RC = @rc