Re: Building one same format for a report from different queries
Are the queries really different or do they just select different departments? If they just select different departments, add a combo to the report to select a department. If the combo's rowsource also includes the email address you need to send the report to, that would make it easier for you.
If you want to send a report to every department, then you don't need to select them one at a time although leaving that as an option gives you flexibility. Your code can check the combo and if there is a department selected, send one report to that department. If the combo is empty, use a VBA loop that reads the department table and send the filtered report for each department.
To make the report include data for only a single department, an easy method is to use the WHERE argument of the DoCmd.OpenReport method.
Bridge Players Still Know All the Tricks