DECLARE @To VARCHAR(500)

DECLARE @MessageString VARCHAR(500)

DECLARE @User1Email VARCHAR(500)

DECLARE @Topic VARCHAR(200)

SET @MessageString ='This script will send an email'

SET @User1Email = 'someone@mars.com' -- use semi colon to seperate many email addresses

SET @To = @User1Email

SET @Topic = 'Test SQL Send Email'

EXEC Master..xp_sendmail

@recipients = @To

,@message = @MessageString

,@subject = @Topic