Send Mail with attachments containing "XXX"

[lena1]

Hello everyone,

I want to send a email according to a Excel file in which I added all the informations for To:, CC: and so on.
Then I want to add two attachments that contain a determined word. This word is defined in the Excel in column A. For example: when sending the email to the people in line 1, then the attachments should be the ones containing the word that is written in cell A1.

Thanks for your help!

[studioX (Horia Belu)]

like this?

where you have:

or you can use column name

and:

make sure in for each row activity to check if the range has or not a header

[lena1]

Thanks, I also thought of this solution with the Path in column A. But since the files are reports that are updated every month I thought it would be easier if in column A was just written the name and the automation recognizes if this word is included in in the file name.
Otherwise I have to change the Paths every month for each line.

[studioX (Horia Belu)]

and sort the for each like created date newest first

where the condition builder on the IF is like this:

[lena1]

Thanks, I think this should work!

What did you enter in the Filepath field in the Get File Info Activity and in the Attachment field?

[studioX (Horia Belu)]

and

and in my run it sent a (2) and b (2) files as they were the newest

[lena1]

Thanks!!