| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding email with 'read receipt' requested in VBA
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Coding email with 'read receipt' requested in VBA
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 Phrank wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Coding email with 'read receipt' requested in VBA
Hi Frank
Click on the Tip link on each example page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Phrank" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Coding email with 'read receipt' requested in VBA
Thanks both! I appreciate this.
On Wed, 31 Jan 2007 09:17:45 +0100, CoRrRan wrote: 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 Phrank wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a receipt or invoice so that the receipt Nos. change automatically | Excel Discussion (Misc queries) | |||
| VBA coding for expiry dates alert threw email | Excel Worksheet Functions | |||
| email a read only doc | Excel Discussion (Misc queries) | |||
| when I email my workbook, it is received as 'read only' | Excel Discussion (Misc queries) | |||
| Adding read receipt to CDO code? | Excel Programming | |||
Linear Mode
