Coding email with 'read receipt' requested in VBA

[Phrank]

Hi,

I've checked out how to send mail in VBA from this site:
http://www.rondebruin.nl/sendmail.htm. This worked great for sending
a short message. I would also like to have it sent with a Read
Receipt included (so the sender is notified when their message is
read). How does that get coded? Thanks.

Frank

 

[CoRrRan]

Once you have an e-mail object active (for example the "OutMail"-object
in the first example (Mail the whole workbook) on that website), and
you're assigning the properties of that e-mail, you can also add the
following line of code:

With OutMail
.ReadReceiptRequested = True
End With

HTH, CoRrRan

 

[Ron de Bruin]

Hi Frank

Click on the Tip link on each example page

 

[Phrank]

Thanks both! I appreciate this.

Once you have an e-mail object active (for example the "OutMail"-object
in the first example (Mail the whole workbook) on that website), and
you're assigning the properties of that e-mail, you can also add the
following line of code:

With OutMail
.ReadReceiptRequested = True
End With

HTH, CoRrRan