Could you provide screenshots of the data with an example of which records the email should include?  You're probably already aware of it but Airtable has a guide for sending an email with a list of records on a schedule:
https://support.airtable.com/docs/how-to-create-email-digests-with-automations

Here's a truncated extract of the data. Pending leave applications must be sent to managers once a week. If there are no pending applications, no email must be sent. I've followed the process outlined in the link you shared - unfortunately, this still sends blank emails when there are no pending applications, hence the cry for help.

Hmm, that looks fine.  I tried setting up the automation you want and ended up with this: 

Seems to do what you want I think, could you have a look at and let me know if it's wrong?
Link to base

Yes, this works. Thanks so much!