February 28, 2024 at 4:17 pm
HI Hi, I have a specific requirement for sending SQL server DB mail. In my scenario, the SQL Server query output should be sent as a PDF or Excel attachment via DB mail. I've successfully sent the query output in HTML format, but now I need the query result set to be sent as a PDF attachment.
My question is How do I output the results of a query to PDF? and attach then send a dbmail?
Regards
v.s.satheesh
February 28, 2024 at 4:22 pm
HI Hi, I have a specific requirement for sending SQL server DB mail. In my scenario, the SQL Server query output should be sent as a PDF or Excel attachment via DB mail. I've successfully sent the query output in HTML format, but now I need the query result set to be sent as a PDF attachment.
Regards
v.s.satheesh
OK, now tell us what your question is:
Remember that questions end with a question mark (?) Simply providing us with a requirement and expecting us to know what you want is laziness on your part.
February 28, 2024 at 4:52 pm
Sorry Edited
February 28, 2024 at 6:59 pm
Don't. Use SQL Server Reporting Services or some other external service.
March 1, 2024 at 2:56 pm
My advice is: never use SQL server email capability for third party apps. Please use third part app to take care of the emailing capability.
DBASupport
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy