Home Forums SQL Server 2005 T-SQL (SS2K5) how to create/send HTML email in SQL and confirm READ without asking? RE: how to create/send HTML email in SQL and confirm READ without asking?

  • August 24, 2015 at 7:22 pm

    #1822123

    halifaxdal (9/15/2010)

    Hello folks,

    I know there are lots of useful script/approaches on how to send out HTML email from SQL, one particular situation I am having is: is it possible to send out this kind of HTML email and know the recipient actually opened it and record the time stamp? Normally the way to ask for a READ receipt is (in outlook) mark the email as "Request for READ receipt" and the recipient MUST click on a button to actually SEND out the receipt, I don't want that, many people don't like that, so I just want quietly record the user's READ time stamp for future reference.

    Besides, creating HTML email seems to be really tedious, is there any good approach that I can create it based on some sort of template? Most solutions I've seen are creating HTML code piece by piece, really cumbersome and not easy for maintenance.

    Thanks.

    To be honest, this would be dishonest and it doesn't actually matter if the person on the other end reads the email or not. All you have to do is prove that you sent the email in good faith.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)