I have developed several batch apps with Access and VBA which, among other things, are started periodically with Windows Task Scheduler. Exactly as isladogs has described. Some apps generate PDF reports that are created with Microsoft Print to PDF and sent as attachments via email to various employees in our company.
This works excellently. I can't think of a better tool to do this work with.