I would like to list all items in an excel that has a column value of Y and then compile that list into a table for an email.
I thouhgt something like this would work.

The condition is if the column has a value of 'Y'. Then create a table of the filtered results and send email with that table as the body of the email.