This does not look too complicated from my understanding of your project description.
Once I take a look at your existing system, figuring out how to send out emails using the user-id's from your access database should be fairly easy and by the time I make the entire delivery, I must also be able to give it to you in a format that it is automated and a one click process for further use in future!
Regards,
Ashwin.