Send email with attachment created from filtered results in a report

Send email with attachment created from filtered results in a report

Hi,

The business case is simple, a operator creates leads for different partners, at the end of the week the user wants to filter the report for a specific partner, and with the push of a button a email is sent to the partner, who email address is kept in a table.

How can I create a automatic action in a report, that sends a email to the partner email address with a attachment that contains the results filtered in the report?

Best regards,
Rui