DECLARE @ServerAddr nvarchar(128)
Set @ServerAddr = 'smtp.gmail.com'
DECLARE @From nvarchar(128)
Set @From = 'sagallagher@mail.bradley.edu'
DECLARE @To nvarchar(1024)
/*You can input multiple recipients and use comma (,) to separate multiple addresses */
Set @To = 'sagallagher@mail.bradley.edu'
DECLARE @Subject nvarchar(256)
Set @Subject = 'simple email from SQL server'
DECLARE @Bodytext nvarchar(512)
Set @BodyText = 'This is a test text email from MS SQL server, do not reply.'
/*User and password for ESMTP authentication, if your server doesn't require
User authentication, please set @User and @Password to '' */
DECLARE @User nvarchar(128)
Set @User = 'sagallagher@mail.bradley.edu'
DECLARE @Password nvarchar(128)
Set @Password = ''
/* If your smtp server requires SSL connection, please set @SSL = 1*/
DECLARE @SSL int
Set @SSL = 0
exec usp_SendTextEmail @ServerAddr, @From, @To, @Subject, @BodyText, @User, @Password, @SSL