Hello,
Is there a way to setup a jet report scheduler that will not email recipients if there’s no data when the report is automatically generated? Any tips or guidance is greatly appreciated.
Date
Votes
1 comment
-
Jet Reports Historic Posts It really depends on the report.
Is this just a standard single report that runs and gets emailed to the same people each time the scheduler runs?
If so, I guess you could create an Excel if statement that states if a certain cell is empty, don't display anything but if there is a value, list out the email addresses.
Then make that cell a named range for emails that the scheduler can use. [see screenshot]
That is just a basic example but I don't know much about the scheduled report so it is hard to expand much more.
Please sign in to leave a comment.