Email receipt code?

  • Thread starter Thread starter Todd
  • Start date Start date
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 "(e-mail address removed)", _
"Test"

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

ActiveWorkbook.SendMail Array("(e-mail address removed)", _
"(e-mail address removed)", "(e-mail address removed)"), "Here's your monthly report", _
ReturnReceipt = Y
 
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("(e-mail address removed)", _
"(e-mail address removed)", "(e-mail address removed)"), "Here's your monthly report", _
ReturnReceipt = Y



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 "(e-mail address removed)", _
"Test"

End Sub
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Confirmation Email Receipt 3
Email workbook without saving 1
Removing Outlook popup box that warns of virus 2
Adding code to a command button 2
Print layout 9
Sorting groups of multiple rows 2
Email with excel 1
command button commands to much 1

Back
Top