How to add email read receipt in VBA.
In a previous post, I explained how to send emails in excel using VBA (send an email with attachments via Excel), but it was an illustration of the core stuff required to send an email via excel, update the information required to control the whole process that why I wanted to make minimal the solution and make it usable for everyone.
Obviously, some readers can’t live on bread alone and have asked how to achieve extras features
Many readers asked how to add the read receipt.
You have to set this property :
.ReadReceiptRequested = True
Where to add it ? in the code you have already in place so that the code will change in this way
There are a lot of other property that you can set and in this Microsoft’s page, you can find the most important and I suppose relevant to you ( a very useful property is “DeferredDeliveryTime” that allows setting the delivery time so you can optimize the
quantity of the emails send according to your email provider limits or the customers local times.).
Once learning how to set one you can easily set the properties you need.