E-mailing a blank report causing stall

[st3ve]

I need to send reports attached to e-mails from an access2000 db.
I have used the sendobject code to do this.

This is fine when the report contains data, but when there is no data to report, the email loop I have set up stalls at the first empty report.

If I run the report on its own, I get a blank report ("errors" etc)- I don't mind if a blank report is sent (or perhaps better to not send a report?) or ideally to send a 'blank' report but with a 'No data to report' type message on it.

But before I get to that point, I need to circumvent the 'stall point' ie. where a report contains no data.

Any thoughts? Thanks for looking.

 

[bjackson]

Try using the no data event for the report, so that the loop will continue
to the next report that has data.