classically this is a job for a batch process
its quite easy (like all office products) to get Access to talk to outlook. Ive done the other way round stripping email from outlook and processing it in Access, so I have no experience to push emails the other way round.
what you would have to do is open an outlook object in Access and create emails to be sent from there. how you do it I dunno. others have sent emails using other processes so those may be a better solution.
the other problem, is the automation part. what I'd suggest you do is consider running this as an overnight process using the windows scheduler opening a copy of Access with appropriate command line switches. the easiest way is to crearte a new Access db with an autoexec macro that identifies data to be emailed and moves them to the outlook data. I'd also suggest that you send an email to another account you have visibility of so you know the overnight process is working this also means you havea copy of what was sent and can get no blowback from the other recipient claiming not to have received the email.
you can do it as part of your existing db, do the work as a specific macro or form / code module, however I prefer such processes to be standalone db's that do specific tasks so there is less risk that people will open a form, code block and run it unexp[ectedly.
I'd rather be riding on the Tiger 800 or the Norton