While writing your message, select the “ Options” tab.This option will send a request for a read receipt with a single message that is sent from your Outlook client. All you have to do is prove that you sent the email in good faith.Request Receipts when Sending Single Message 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. 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.īesides, 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. This is exactly what you see on a daily basis in your spam 's how they can test your email address and if you open/downlaod the image, they know they can sell your email or dump a ton of spam at you. So if the end user has enabled the images in the email browser, you know if they opened it One sleazy way to know if someone opened an email is to have the src of an img tag be processed by a server side script, that was passed a uniqueId Since the sending a return receipt / read receipt is an option, there's no guarantee that you'll get responses for the emails you send out. It would probably be easier to create an application which reads the mailbox and if the email address or a certain unique id in the message or body exists, you can have the application update the database for the row that is referenced by that unique value/ email it was sent from.
So there is no wat to do what you are asking from within SQL anymore. Was removed when sp_send_dbmail was introduced The ability to READ emails ( the read receipt IS an email) You'll have to create something in code or in CLR
0 kommentar(er)
