I am presently working on a MS Access ('97) database that I have built
several tables, linked them and have all the information tied together
into a query. This information from the query is displayed on a form
built for that purpose.

What I would like to do is have a button (or couple buttons) on the
form to output parts of this query to a document (such as an Excel
spreadsheet, etc.) that can be emailed to those that require this
information.

The particulars to this are as follows: The query contains alot of
information. I want the ability to send certain fields of data to
certain people/groups. I would also like the ability to have prompt's
for filtering the data before it is compiled. For example, one of the
fields is a work group. I'd like to be able to click a button on the
form showing the data, be prompted as to whether to filter this work
group field via a particular entry, or provide data for all work
groups, then develop a document sufficient for emailing.

Thanks, Robb