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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nikki - 25 May 2006 04:58 GMT

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?

Reply to this Message

Steve Schapel - 25 May 2006 05:24 GMT

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

Signature

Steve Schapel, Microsoft Access MVP

> 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?

Reply to this Message