I have macros in MS Access that email reports to groups of people. I am trying to work a way where I run a macro and it will send the specific report to each person. I have a list of 52 membership invoices that go out annually. Is there a way to get the query or macro to send the specific invoice to each person? Currently I have to create 52 seperate invoices and send out 52 emails.