I'm reasonably experiences with jet and use the scheduler to generate and email a number of different reports. However, I have a new one and I'm not sure how to go about it.
We have a cash flow report run for each supplier that calculates if/when we're going to go over our credit limit based on purchase orders. I can set up a scheduler to run the report for each supplier and to email to management. However, I only want to email the files that go over the credit limit, which I won't know until after I've run the report. If I was running them individually I could use a named range for the email, but is there anything I can do with the scheduler?
