Create a button that prints a report and emails a different report

[Guest]

Is it possible to create one button, when clicked prints a report and emails
a different report to email addresses based on a query?
Alternatively one button that prints a report and another button that closes
the form as well as emailing the second report?

Any ideas?

 

[Steve Schapel]

Nikki,

If you are planning to use a macro to do this, use an OpenReport action
to print the first report, and SendObject to email the second report.
There is no problem with having more than one action in the one macro.

However, the SendObject macro is limited to one email address. You
might find some good information about alternatives here...
http://www.granite.ab.ca/access/email.htm