Snapshot with stLinkCriteria

  • Thread starter Thread starter Ripper
  • Start date Start date
R

Ripper

Access 2003 / 200 format. I have a report that opens toa specific record.
The report title is "rptDisc-ISS" and the criteria that is has is the DiscID
from the current record. 2 questions:

1. How do I create a macro that will export the same report, using the same
criteria, as a snapshot and connect it to an email for sending out?

2. Is it possible to add the recipient's email in the TO: box from a field
in the record? If so how?
 
Rip,

You can use the SendOject action in your macro to send the report by email.

However, this action does not support a Where Condition argument, so you
need to apply your condition to the query that the report is based on.
Let us know if you need more help with this aspect.

And yes, you can add the recipient's email address, by entering the
equivalent of this in the To: argument of the OutputTo action:
=[NameOfYourEmailField]
 
Back
Top