This would be very easy to do using some VBA code (a "module" in Access, which you can then run from a "macro"). Basically, query the two tables into Recordsets, and loop through them.

Hello,I created a database that loads and runs a report upon onload. After that, I have it sending the object (report) to an email address through outlook via a macro in Access. I keep getting ...