Post reply

SQL server DB Mail

  • February 28, 2024 at 4:17 pm

    #4386484

    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

    #4386485

    vs.satheesh wrote:

    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:

    • How do I output the results of a query to PDF?
    • How do I output the results of a query to Excel?
    • How do I add an attachment to a DBMail message?
    • something else?

    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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 28, 2024 at 4:52 pm

    #4386500

    Sorry Edited

  • February 28, 2024 at 5:37 pm

    #4386532

    vs.satheesh wrote:

    Sorry Edited

    Bravo, that's much better.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 28, 2024 at 6:59 pm

    #4386591

    Don't. Use SQL Server Reporting Services or some other external service.

  • March 1, 2024 at 2:56 pm

    #4387688

    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 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply