multiple queries in report?

[scott]

I have a few queries that I send to my boss everyday. The queries show
each dept in our business and what the employees do every day.

1 query show one dept and how many calls they took a day and how long
they were on the phone

2nd query shows our billing dept and how many projects they did.

3rd query is our email dept and how many emails they did and what
their turnaround time was.

Right now I have a macro that sends all 3 queries in excel format as 3
files to my boss.

Is there any way to put these 3 unrelated queries in a report all nice
and formated and then send that to my boss?

Or put them all in a word doc formated automatically by running a
macro?

Thanks
Scott

 

[scott]

Thank you very much..I was playing around with this and it works
great!

Scott