I can find a bunch of similar topics covered but for the life of me can’t quite find an answer to this specific issue, apologies if I’m just being stupid.
I have a dataset run once a week checking for errors in processing on one of our systems. Each set of relevant errors will need to be emailed to the person responsible for them. If there are no errors found, I want to email the people who don’t have any with a separate email, so they at least know that we’ve checked for them, not that our checks are broken.
One table of data (‘Dummy Data’) and one table of email address that relate to a name field in the dummy data (‘Email Addresses’)
I’ve successfully set up the loop for filtering the data, creating the files (with variable names), and sending out an email to the relevant person, however I can’t seem to quite understand how to use the empty table switch for when there is no data related to that person/email address so that I can create the other email.
I know that I shouldn’t have another Loop End, but I’ve tried End If and connecting it all together and I just can’t quite get it to work.
Appreciate your wise guidance as always.