I have a list of suppliers, each with their data and emails in Excel.
I have a folder containing PDF payments from vendors.
An email must be sent, using the excel list,
and the corresponding file must be included, from the suppliers folder.
In order to find the corresponding file, the robot must search inside each file, in the suppliers folder.
You must search for the name of the receipt holder.
The name of the receipt holder is the same as the one in the excel list, this would be the match.
In this way, search for each corresponding file and send it to each corresponding contact.
If anyone knows how to do this I would greatly appreciate it.