In this article I will explain with an example, how to send email with query results as attachment in SQL Server.
This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 and 2022.
 
 

Configuring SQL Server for sending emails

In order to start sending emails, the very first thing to be done is to configure SQL Server for sending emails from Database.
Thus, in order to achieve the same, please refer my article Configure SQL Server for sending emails.
 
 

Sending Email with query results as attachment in SQL Server

Once the SQL Server Database is configured for sending emails, you are now ready for sending emails with query results as attachment.
In the following SQL query, the Stored Procedure sp_send_dbmail is used to send an email from SQL Server.
EXEC msdb.dbo.sp_send_dbmail
    @profile_name ='Mudassar_Email_Profile'
   ,@recipients ='recepient@gmail.com'
   ,@subject ='Email from SQL Server'
   ,@body ='Customer Details.'
   ,@importance ='HIGH'
   ,@query ='SELECT CustomerId, Name, Country FROM Customers'
   ,@attach_query_result_as_file = 1
   ,@query_attachment_filename='Result.txt'
GO
 
Once executed, the following messages will appear which confirms, your email has been queued.
SQL Server: Send email with query results as attachment
 
 

Checking Emails Status and Errors using Log Tables

Once the Stored Procedure sp_send_dbmail is executed, the mails are queued and then sent.
In case you do not receive email, then you can find the status of email i.e. sent, unsent or failed using my article Find email sent status using sysmail_sentitems in SQL Server.
 
 

GMAIL SMTP Errors

The possible errors (exceptions) occurring while sending email using GMAIL SMTP are covered in the following article.
GMAIL Error: The SMTP server requires a secure connection or the client was not authenticated
 
 

Screenshot

Mail

SQL Server: Send email with query results as attachment
 

Attachment

SQL Server: Send email with query results as attachment
 
 

Downloads

Download Code