Pick files from folder and add as attachments in email

Lakshmikanth_2021

I have below worksheet, where file 1, file 2 .... are the files places in a specific folder.

For section 1, I need to send an email by attaching the files, where it is marked as yes.

Here in this example, for section 1, I need to attach the files File 9 and File 10.

for section 2, I need to attach the file 2.

for section 3, I need to attach the files, file1, file 2 file 3 file 4 file 5 file 6 and so on..

	File 1	File 2	File 3	File 4	File 5	File 6	File 7	File 8	File 9	File 10
Section 1									Yes	Yes
Section 2		Yes
Section 3	Yes	Yes	Yes	Yes	Yes	Yes
Section 4			Yes
Section 5			Yes
Section 6			Yes
Section 7			Yes
Section 8						Yes	Yes
Section 9								Yes	Yes
Section 10

Workflow

Datasets

Reporting

Custom Tools

Parse

Macros

Batch Macro

Preparation

Data Investigation

Documentation

Accepted answers

All comments

DylanDowrick

Do they need to be in the same email? Or can Section 3, for example, be sent as 6 separate emails?

FinnCharlton

Hi @Lakshmikanth_2021,

To do this, you should transpose your data and then add a file path based on the file to be attached. You can then configure the email tool to attach that file using the FilePath field:

Hope this helps

Files As Attachments.yxmd

Lakshmikanth_2021

Yes you are right. I need separate emails for every section

Taylor_S

Hello! This can be done a couple of ways depending on how you want it to work. If you want to just build the workflow and have it run on command, the below should work. You would just need a filter for each Section and then a corresponding email tool.

But if you want to simplify the workflow so you don't need all the filters, you COULD turn this into an analytic app that sends the emails when you select them from a drop down as well.

email app.yxwz

Email Q.yxmd

Lakshmikanth_2021

Thanks a lot for the quick solution.

Actually in my scenario, the number of files like file 11, file 12 might keep extending and also sections might keep extending, is there a way that I can loop

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703