Chris Harshman (12/1/2016)

---

the obvious answer would be sp_send_dbmail:

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

I prefer to use the @attach_query_result_as_file=1 option, because the results are often easier to read in the text file than in the body where outlook would spoil the formatting.

is database mail not setup in your environment?