Email on button Click

[Hamill]

Hi



I am an absolute bunny with access but I have created a database where staff fill out a form to apply for leave and when they press a button I would like an email to be sent to me (the boss!) so I can open up the form and approve the leave. The email will be exactly the same each time as it is just a flag for me to open up the database. I am using access 2016. I have looked and some people use a send email macro but I cannot seem to see that one in my database

Can someone help

Thanks

[ranman256]

docmd.SendObject acSendreport ,"rpt2Email",acformatPDF,txtTo,,,txtSubj,txtMessag e

[Hamill]

Thanks (I think) As I said I am a bunny at access and have copied the above into a module and changed the to the following but if gets grumpy and says compile error (email address is not real at the moment)

I don't to actually send anything except a statement in the subject : "Leave application has been submitted" to john@hamilton.kiwi

The following is what I tried and got an error - keeps on highlighting the word hamilton


docmd.SendObject acSendreport ,"rpt2Email",acformatPDF,john@hamilton.kiwi,,,Leave application has been submitted,Leave application has been submitted

[pbaldy]

Most arguments are strings. Try

docmd.SendObject acSendreport ,"rpt2Email",acformatPDF,"john@hamilton.kiwi",,,"Leave application has been submitted","Leave application has been submitted"