Is a query like this Possible

[MiscAlma]

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

is all this possible from 1 button?

 

[Deleted member 147267]

maybe OutputTo will work for you
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.outputto

or

sendobject
https://docs.microsoft.com/en-us/office/vba/api/access.acsendobjecttype

 

[MiscAlma]

Thank you very much I found out about the email macro but I wanted the three reports to be send together!

 

[Deleted member 147267]

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.