How to schedule auto-exporting MS Access query to Excel and email it?

[dchen]

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.

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?

If this can only be done in VBA, any reference I may start with?

Thanks.

[June7]

Maybe email with CDO (Collaboration Data Object). https://www.accessforums.net/access/...nding-216.html

[ranman256]

I have a form, with the users in a list
the form has a timer, timerinterval = 5000 (5 seconds)
it checks the target time, if it hits, then it launches :

exports query to excel
builds email via code, attches xl file, send.
(tho it does seem to work better if Outlooks is open)