SendObject

  • Thread starter Thread starter Ngan Bui
  • Start date Start date
N

Ngan Bui

When using the SendObject function to send a report as an
attachment in an email, is it possible to filter what
record the report shows?

When I'm on a record, I want to use the SendObject
function to send a report specifically for that one
current record.

currently, I have two reports, one that doesn't have any
filters, another where the filter is set to whatever the
current record is.

Is there some function that works with the SendObject like
the WHERE criteria in the OpenReport function?
 
Open the report in preview mode, and use SendObject while the report is
open.

(david)
 
do you know how to do this from a form ?? thanks
-----Original Message-----
Open the report in preview mode, and use SendObject while the report is
open.

(david)




.
Click to expand...
 
Open the report in preview mode, and use SendObject
do you know how to do this from a form ?? thanks
Click to expand...

You have to attach an [event procedure] or a macro to
an event on the form or control. Then in that procedure
or macro, you use OpenReport to open the report, then
SendObject to send the report. Be sure to open the report
in preview mode.

If you have not used VBA before, it will be easier to
create a macro that does the OpenReport action and
SendObject action.

(david)
 
Back
Top