If file name matches with value in excel send outlook email with pdf attachments

[Rohith_Shastri]

Dear all,

Good day,

I have a lot of PDF(Like, Certificates) placed in the folder and i have a list of email ID.

I want to send the particular PDF(Certificates) But i want to attach only pdf that matches filename with the value that i am getting from a excel sheet

Please any one guide me how to design the flow or please share the flow

Kindly assist.

Thank you

[Marius_Puscasu]

Hello @Rohith_Shastri ,

One simple solution would be like this:

Used activity references:

• https://docs.uipath.com/activities/docs/read-range
• https://docs.uipath.com/activities/docs/for-each-row
• https://docs.uipath.com/activities/docs/send-outlook-mail

Hope it helps!
Best regards,
Marius

[Rohith_Shastri]

It should take the files automatic from the folder

[Marius_Puscasu]

Hello @Rohith_Shastri ,

Yes. It takes the files automatically from the folder.
However, the mapping (which email address receives which file) should be defined by you (as an excel file, for instance)

Hope it clarifies the issue!
Best regards,
Marius