Dynamic report and send results via email

A

annettem

I would like a process on send emails, with a specific report
attached. For example, I have a 911 database that I would like to
extract calls, by muncipalities, and send the results to the Chief of
Police of each of the municipalities.

I was thinking of having the municipality name and email address in a
table. Then *somehow* use the municiaplity name in the query to
determine the report results. Also use the email address to send the
report.

Any comments or suggestions on how to get this to work would be great.
It sure would be nice to have it in a script to run. I was thinking of
a macro to fire this off, but need some good pointers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top