Filter Excel table and send mail

Hello everyone,
I have an excel table with the columns “Agency” and “File Status” and “Mail of the agency”
I want to filter the table by “Agency” then send the files that are attached to that agency with en Email.
How to do ???


Use filter datatable activity or you can use select query to filter datatable and then use send mail activity to send the file

let us know if this helps.
Pavan H