Attach all files from a directory and email it

I've been looking for a clear solution for this but haven't found one so I'm putting a new post out....

I want to be able to build a process that goes and reads a directory and pulls all the files from the directory and emails it to email address based on a list of email

Second function is to pull a file from a directory - read the file in an input - then output it to a database

Developer

Help

Dynamic Processing

Accepted answers

TomHH

Hi @jepalteryx ,

You can use the Directory Tool to read in the file paths from a given folder. Once you have the file paths you can configure the email tool to attach files from the field value from your input.

Let me know how you go.

All comments

TomHH

Hi @jepalteryx ,

You can use the Directory Tool to read in the file paths from a given folder. Once you have the file paths you can configure the email tool to attach files from the field value from your input.

Let me know how you go.

jepalteryx

I just tried and it did send the email with the attachement but if I have more than one file in there it sends a separate email for each attachment. How do I send all the attachments in one email?

TomHH

Hi @jepalteryx , to send out all the attachments in one email you'll need separate columns for each attachment - so one record has the email address and n attachments. This is pretty straight forward when you have a fixed number of attachments but a little bit more complex when you want to dynamically update the attachments.

If you're comfortable building macros with xml you can use the first solution, however you can try the solution at the end which sorts and then sends the emails based on the number of attachments - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Email-Batch-Macro-With-Varying-of-Attachments/m-p/478604/highlight/false#M96089

Hope that helps!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703