send query output in database mail

How to send a SQL Server Query result in e-mail message?

If we have configured SQL Server Database Mail then we can easily send query result as an attachment in mail body.