You can write a query block into the Access database to handle the sending of the emails. You would need to write some software to open the Access database and run the query.
VBA should include the ability to send email.
There is a way to include SMTP functionality within Access itself to send emails. Write a VBA module to do this. Build a macro called autoexec that invokes the VBA module, then exits Access. You can then create a Windows Scheduler job to open the database at a specific time. The database will open, send the email, then exit. When you need to get into the database, hold down the [Shift] key to skip the autoexec macro execution. Or create a mail-only database with links to the tables and use that one for the nightly mail job.