Email Section to Excel Column Email List with Two Conditions

[MiceElfandEye]

In TabA
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD]Test1@email.com[/TD]
[TD]test2@email.com[/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]testb@email.com[/TD]
[TD][/TD]
[TD]N[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]testc@email.com[/TD]
[TD]test4@email.com[/TD]
[TD]Y[/TD]
[TD]N[/TD]
[/TR]
</tbody>[/TABLE]


Hello, thank you to anyone who can help.

I need to email Columns A-G in TabB to the email addresses in (TabA) column A and (TabA) column B if it has an email address in it, if (TabA) Column C has a Y. In addition, I need it to .display instead of .send

I've done a few email codes before but this has me stumped. Any help would be greatly appreciated.

MiceElfandEye