then you need to open a filtered report, save it as PDF (you can do this in the front-end folder = CurrentProject.Path) then attach that to a new Outlook message.
Why not just sendobject as pdf instead of creating one?
Might depend on whether or not the report is already filtered by its query. Then there's OutputTo method as well, once the report is opened with a filter if necessary.
Last edited by Micron; 10-08-2021 at 05:42 PM.
Reason: added comment
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.