How to send email to multiple tabs in excel

Help
1

My objective is to send an email to the person who indicated as ‘N’ under column C for all the tabs (Sheet 1 and Sheet 2) in my excel.

The workflow I have attached would send an email to the person who indicated as ‘N’ under column C, but it sends the email twice (to a@gmail.com) (I suspect it’s because there are two tabs in the excel).

I’m not sure what makes the workflow send the email twice even though there is only one person who indicated as ‘N’ in the first tab.

Please help me rectify the problem, I have attached the workflow and excel below:
Test Email - Forum.xlsx (14.2 KB) Main - Forum.xaml (12.3 KB)

2

Hi,

while looping through sheets inside range activity give item as value instead of “sheet1”.

Thanks.

3

Where should I change that?

4

in read range activity make sheet name as item inside the for each

5

I don’t understand, so in the read range now is “Sheet1”. So I should change it to “SheetName”?