I'm not an access person, but this seems like a task a database and some scripting glue could do in its sleep. The only state you need is a list of email addresses that have been emailed. The rest is "look at address, if it isn't in the list, email and add to list, otherwise do nothing"

I don't know if access is the right tool, but mysql/perl/php should be able to do this easily.

Matthew