Yes, this is possible to do with Access. Since I'm in Belize at the moment, I don't have time to whip up a proof of concept, but it is possible.

Check out using the blat dll as a free way to send email from Access without automating Outlook (ick!). If you're still hammering away at this after Nov 8th or so when I get back, I'd be happy to help you out.