I need your help in creating a logic for the below scenario.
I tried to create one logic but am confused.
I have 2 excel files.
The first excel file have some app codes like below.
The Below file is generated on daily basis and data in the column E can be in different.
The 2nd Excel file have the email ids corresponding to the app codes in the first excel file.
So I want to create a logic where BOT will pick app code from the 1st excel file and will automatically pick the corresponding email address from the 2nd excel file.
The data in 2nd excel file will be Fixed ( no changes will be made in the 2nd excel file )
Example if the app code selected by BOT is PSG_DBSAPP_EDGE then it should send an email to – firstname.lastname@example.org