I have some simple query's that I would like to run and send via email from Access 2010
I have created a macro using the EmailDatabaseObject. It all works as expected, but Outlook has to be open for it to run. Is there a more sophisticated way to set this up? I'm looking to email reports on a certain day/ Time to users, without having to have outlook open.