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.
You can do anything you want with code. Use three TransferText commands to export the three queries to separate sheets of the same Workbook. Then use the Output to email the spreadsheet you just created.
