I want a button to be able to able to run 3 different queries (Already Done)
After that copy the tables and put the tables in a ms outlook email Ready to be send
You said nothing about a report. It sounded like you were going to run 3 action queries then send the tables with the changes.
I have no code handy for this, so the best I can do is offer at least 1 result from a 10 second search
that has at least one method. Probably someone will chime in with their version, but there is ready made code at that link.