title: How to schedule auto-exporting MS Access query to Excel and email it?
body: <p>I know Access can setup an Outlook Task to auto-export query to Excel, but it requires the Outlook to be always open on the user's computer.</p>
  
  <p>Is there an easy way to setup a schedule that can automatically export a query to Excel and this schedule will then auto-email the exported Excel file to an email address every Monday at 5AM for example?</p>
  
  <p>If this can only be done in VBA, any reference I may start with?</p>
  
  <p>Thanks.</p>