SendObject

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

 

[david epsom dot com dot au]

Open the report in preview mode, and use SendObject while the report is
open.

(david)

 

[amy ratcliffe]

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)




.

 

[david epsom dot com dot au]

Open the report in preview mode, and use SendObject

do you know how to do this from a form ?? thanks

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)