Hi -
I am trying to set-up an automatic (i.e. no human action required) 'alert' system which will send an email (to a group of people) stating that an action is now overdue.
At the moment I am using SendObject to email the relevant query but I am having some troubles...
Firstly, I'd like the SendObject to automatically run when the Access database is opened but it won't. Is there another or different macro I could use? Note, in time I'd also like to set the task scheduler to open the file automatically at defined time.
Secondly when I run it manually, I am greeted with an Outlook pop-up window where I have to allow or deny to email to be sent. Is there a way around this?
Secondly, SendObject adding the results of the query as an attachment to the email, is there a way to have the results in the main body of text instead?
Apologies if these questions sound noob!