I've come up with a solution. There is probably a better, more simple one, but Ithinkt his will work. I changed your queries so they would select all employees:
In Access with the report open, go to File on the menu bar, select Send To, then Mail Recipient (as attachment). Then select format. Snapshot view work best...