Sending basic an email: [code lang=”sql”] EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘BH_PRODMAIL’, @recipients = ‘oguzhank@ycn.net’, @body = ‘The stored procedure finished successfully.02’, @subject = ‘Automated Success Message02’ ; [/code] Sending an email with attached result-set file: [code lang=”sql”] EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘BH_PRODMAIL’, @recipients = ‘oguzhank@ycn.net;oguzhank@ycn.net’, @query = ‘ SELECT tbl_a.column01 AS "My Column Name 01", tbl_a.column02 AS "My Column Name 02", tbl_b.column03 AS "My Column Name 03" FROM BK_ROM_WOR.dbo.table_a tbl_a (NOLOCK), BK_ROM_WOR.dbo.table_b tbl_b (NOLOCK) WHERE tbl_a.a = tbl_b.b ‘ , @subject = ‘Email Subject’, @attach_query_result_as_file = 1 @query_attachment_filename = ‘SQL output.txt’; [/code] Sending HTML content with dynamic date: [code lang=”sql”] DECLARE @tableHTML NVARCHAR(MAX) ,@SubjectTxt nvarchar(max) ,@StartDate datetime ,@EndDate datetime; SELECT @StartDate = GETDATE()-8; SELECT @EndDate = GETDATE()-1; SELECT @SubjectTxt = ‘Subject — ‘ + CONVERT(varchar, FORMAT (@StartDate, ‘yyyy-MM-dd’), 101) + ‘ — ‘ + + CONVERT(varchar, FORMAT (@EndDate, ‘yyyy-MM-dd’), 101); SET @tableHTML = N'<H1>’+@SubjectTxt+'</H1>’ + N'<table border="1">’ + N'<tr><th>Colum A</th><th>Column B</th>’ + N'<th>Column C</th></tr>’ + CAST ( ( SELECT td = tbl_a.column01, ”, td = tbl_a.column02, ”, td = tbl_b.column03 FROM BK_ROMS_WOR.dbo.table_a tbl_a (NOLOCK), BK_ROMS_WOR.dbo.table_b tbl_b (NOLOCK), WHERE tbl_a.a = tbl_b.b AND a.bdate between GETDATE()-8 AND GETDATE()-1 FOR XML PATH(‘tr’), TYPE ) AS NVARCHAR(MAX) ) + N'</table>’ ; EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘BH_PRODMAIL’, @recipients = ‘oguzhank@ycn.net;oguzhank@ycn.net’, @subject = @SubjectTxt, @body = @tableHTML, @body_format = ‘HTML’ ; [/code] Send SQL result as CSV file via SQL Server: [code lang=”sql”] EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘DMAIL’ ,@recipients = ‘oguzhank@ycn.net;el@ycn.net’ ,@query = ‘ EXEC P_iSP_DB.dbo.SP_RPT_PRO_MIX_ORD_DIS @StartDate = ”2021-04-01”, @EndDate = ”2021-04-30”, @Restaurant = ”1158,6318”, @OrderType = ”2,0,1” ,@BrandID = 0; ‘ ,@subject = ‘PMx-20210401-20210430-P’ ,@attach_query_result_as_file = 1 ,@query_attachment_filename = ‘PMx-20210401-20210430-P.csv’ ,@query_result_separator = ‘,’ ,@query_result_width = 32767 ,@query_result_header = 1 ,@query_no_truncate = 0 ,@append_query_error = 1 ,@exclude_query_output = 0 –show execution result ,@query_result_no_padding = 1 –remove spaces; [/code] For more information, you can visit this site.]]>