Access and Auto e-mail

Greetings All

Here’s my problem. I need to automatically e-mail files as attachments.
The problem is that the file locations are stored in the results of an Access 97 query, I need some way of interogating the results and pick up the file names and e-mail addresses to which to send them. This would need to run every day at the same time automatically.
My Access knowledge is limited so weather this is a plug in option or not I have no idea. Or even if it’s possible.

Regards
Andy