Email receipt code?

T

Todd

What would the code be to add an email receipt that the
file was opened to the sender of the file? The code I
have so far is:

Private Sub CommandButton3_Click()
ActiveWorkbook.SendMail "[email protected]", _
"Test"

End Sub
 
R

Ron de Bruin

ReturnReceipt:=True

I don't add it to my site because it is not working for me and I hate it<g>

--
Regards Ron de Bruin
http://www.rondebruin.nl


David McRitchie said:
From a posting by Ron de Bruin and probably not on his site
[ http://www.rondebruin.nl/sendmail.htm ]

ActiveWorkbook.SendMail Array("[email protected]", _
"[email protected]", "[email protected]"), "Here's your monthly report", _
ReturnReceipt = Y

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Todd said:
What would the code be to add an email receipt that the
file was opened to the sender of the file? The code I
have so far is:

Private Sub CommandButton3_Click()
ActiveWorkbook.SendMail "[email protected]", _
"Test"

End Sub
Click to expand...
Click to expand...
 
Top