Add multiple attachment based on cell value in attachment

Hi Everyone,

I have a requirement - 10 excel files is available in folder i need RPA to compose email and it should attach multiple excel files based on the cell value inside the workbook.

Ex - Mail composed for supplier ABCD once its composed it should read all excel workbook and it should attach all excel which is having the supplier name of ABCD ( Supplier name will be available inside the workbook in fixed cell)

This is basically to send the rejected files to supplier so based on supplier code email id will be taken after that i need to attach respective supplier files.

Looking forward your support to meet my requirement.

Thank you !