How to send a SQL Server query results in e-mail message
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.
Home ยป
msdb.dbo.sp_send_dbmail
SQL Server Database Mail Configurations
SQL Server Database Mail is used to send e-mail from the SQL Server Database Engine to user. We can also send an output of any stored procedures or table records in e-mail as an excel attachment or in HTML format in e-mail body.