Kevin Wilkie says you’ve got mail:
For the many other parameters you can use with sp_sendmail, please refer to the Microsoft Documentation found here.
After running this stored procedure, SQL Server queues the email to be sent. From there, you should check often to see if it was actually sent. (And yes, it can get stuck there forever.)
With, Snowflake, it’s actually fairly close to the same basic principle as SQL Server.
Click through for the syntax for both systems.