My objective is to send an email to the people who indicated ‘N’ under the column ‘UPDATED?’. However, I have 2 sheets (Sheet1 and Sheet 2). How do I read range the multiple sheets and combine them into one output Data Table?
Main.xaml (9.4 KB)
Test Email.xlsx (14.2 KB)