Send Email - Sample


EXEC msdb..sp_send_dbmail
      @profile_name = 'SQL Server - MSSQL
      ,@recipients = 'youremail@email.com'
      ,@subject = 'SQL Server - Test'
      ,@body_format = 'HTML'
      ,@body = '<br> <h1><font color=red>You can execute it in HTML language if you want do it.</font></h1><p>'


For more parameters:
https://msdn.microsoft.com/en-us/library/ms190307.aspx