E-mail with object

  • Thread starter Thread starter Johnny
  • Start date Start date
J

Johnny

I have a report I want to send with an e-mail, but how can I make a filter
or where-conditions so I can send a single report, not all of them? I am
using a sendObject command.

Sincerelly

Johnny
 
Sorry, you don't have the Filter / WhereCondition like the OpenReport
method.

You will need to modify the Query you use as the RecordSource to include the
criteria BEFORE you execute the SendObject.
 
Hello

I'm assuming you're using a command button to send the report? If so, then
try basing the report on a query and set the form ID as criteria for the
query. e.g. if you want to send the current form's details, have the
criteria in the query as Forms![form name]!FormID

Hope this makes sense.

Let me know if you need more help

Rebecca
 
Back
Top