How To Find Specific Files With Matching Naming Convention from Folder And Send All Matching as One Email Attachment

Help Studio
, ,
1

Hi,

I am looking to solve an issue where I have multiple files in one folder and I need to find all the files beginning with “RWJBH_PB_BREG” as one attachment (NOT MULTIPLE). I tried using the For Each File in Folder Activity and looking for specific name, but issue is it sends multiple email (Using Send SMTP Mail) as opposed to one. Once it is done emailing I would like to archive these files under archive folder.

See the attached screenshot. All the highlighted I would like to send as part of one email attachment as opposed to multiple.

The image shows a file directory named "EPICBREGDMEREPORTS" with various CSV and XLSX files related to financial and insurance reports, along with their modification dates and file sizes, with some files highlighted in a red box. (Captioned by AI)
The image shows a file directory named "EPICBREGDMEREPORTS" with various CSV and XLSX files related to financial and insurance reports, along with their modification dates and file sizes, with some files highlighted in a red box. (Captioned by AI)1063×222 18.2 KB

The image shows a "For Each File in Folder" loop setup from an automation script, with specified folder paths and conditions for processing files. (Captioned by AI)
The image shows a "For Each File in Folder" loop setup from an automation script, with specified folder paths and conditions for processing files. (Captioned by AI)439×384 15.4 KB

The image shows a software workflow with a conditional expression editor in UiPath, evaluating whether a variable contains a specific string to determine subsequent actions. (Captioned by AI)
The image shows a software workflow with a conditional expression editor in UiPath, evaluating whether a variable contains a specific string to determine subsequent actions. (Captioned by AI)1022×448 24.9 KB

The image shows a workflow process for sending an email with a configured HTML body, including components like message configuration, log level, recipient details, subject, and an option to attach files. (Captioned by AI)
The image shows a workflow process for sending an email with a configured HTML body, including components like message configuration, log level, recipient details, subject, and an option to attach files. (Captioned by AI)393×364 15 KB

The image shows a flowchart of an automated task sequence involving sending an email and moving files to an archive folder. (Captioned by AI)
The image shows a flowchart of an automated task sequence involving sending an email and moving files to an archive folder. (Captioned by AI)374×433 16.4 KB

2

If you want to send a single attachment you’ll need to compress the files into a zip. You can do it with Compress/Zip Files activity

The image shows the UiPath interface with a search for the "Compress/Zip Files" activity in the Activities panel, highlighting its description that it adds files or folders to a compressed (zip) file. (Captioned by AI)
The image shows the UiPath interface with a search for the "Compress/Zip Files" activity in the Activities panel, highlighting its description that it adds files or folders to a compressed (zip) file. (Captioned by AI)477×245 8.14 KB

I suggest you use your existing iteration to copy the file to a temp folder, then, outside For each, zip the temp folder and send the email.

3

Hi @nirmit.kansagra

You can create an array and keep appending it in the loop with the file paths of the files whenever a match is found.

Move your archive folder and send email out of the current loop.

Outside the loop, use your send email activity and in its properties you will find attach collection option.
So, instead of attach files, you use attach a collection to upload items from your array variable there.

Then next loop to move files to archive folder.

Alternatively,
you can consider switching your first loop with directory.getfiles activity to fetch the list of the list that match the criteria.
And simply use its output to attach as a collection in send email activity.
Then only 1 loop to loop through this list to move files to archive.

Hope this helps.

Let me know if you have any further queries.

Regards
Sonali

4

could you share screenshot of this if possible so i can understand it better.