As it says above basically.
I have an excel sheet with 3 tabs. each one may or may not have data as they are dynamic in nature. In my email, I want to include the data from each tab into the email body with some text in between. If there is no data in a table, then I want some text instead.
Table 1 data
(insert dynamic data from tab 1)
Table 2 data
(insert dynamic data from tab 2)
Table 3 data
(no data in this table so “no data to show” text)
I hope this makes sense. I have the email body sorted with the joining text etc, these are the last bits.
Thank you in advance