Hi @SVA
Do you want to send the result in excel format?
You seem to give little information.
Can this thread help you?
Best regards,
Percy Tang
Database mail with excel attached with a format way
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SVA
121
Reputation points
Hi
How to send a query output in excel with a formatted way in runtime by using EXEC msdb.dbo.Sp_send_dbmail.
SQL Server | Other
{count} votes
-
SVA 121 Reputation points
2023-05-11T05:41:06.74+00:00 Version of SQL Server is 2017
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-05-11T05:59:31.48+00:00 -
SVA 121 Reputation points
2023-05-11T06:27:06.9533333+00:00 Yes to send the result in excel file with formatted. Each column mapped to each column in excel.
Sign in to comment -
-
Olaf Helper 47,586 Reputation points2023-05-11T06:41:11.7666667+00:00 How to send a query output in excel with a formatted way
You simply can not.
What do you expect, SQL Server is a database server, not an application server.
Use an application server or at least a PowerShell script to generate & format an MS Excel file; SQL Server can't do this.
-
SVA 121 Reputation points
2023-05-11T08:11:34.1566667+00:00 There is any powershell script to generate excel file
Sign in to comment -