Instead of scheduling the report to email to a destination in the usual way, consider setting up a report alert instead - set the alert condition to apply if the count of records is greater than zero (to make it run every time) - and you can then pass through the value of the variable into the alert message.
Deb Taylor
Sheffield, UK