I am creating a form in MS access, I'd like to put a button on the form which will e-mail a report to the "relevant people."
I found a button in the tool box and if you click on reports there is an option for "Mail Report"
This will only attach the report to an e-mail, then you have to type in the "relevant people" on the e-mail then press send.
I'd like to and I presume it'll need some code (not my strong point) automate this more, i.e. (because I'm lazy)
1) Click the mail to button on the form.
2) Outlook (default e-mail) opens a fresh e-mail with the report attached, also I'd like the "relevant people" to be automatically written into the e-mail so all you have to do is press send on the e-mail.
Thanking you for your help in advance.