Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Using concatenated file paths to send multiple email attachments

A_Harkleroad
5 - Atom

Hoping to get some help on how to get my files attached successfully into one email. 

 

I'm using the directory tool to check a specified folder. The filter tool then looks for files with certain key words and I'm using the Summarize tool to concatenate the file paths of the file names that match the attributes I have set using the filter tool. I do this because the files available would vary weekly (some weeks will have just the MAS, another week the folder could contain all three and I want to send what files are available that week).I used semicolons as separators and ensured there's no leading/trailing space or other characters.

 

 

A_Harkleroad_0-1753383938850.png

 Within the email tool's attachment section, I'm selected file name from field value and added the field containing the concatenated file path. When I run the workflow, it says that it cannot read the file. 

A_Harkleroad_1-1753384749291.png

I noticed that it removes one of the backslash after the first file path in the email tool error message. Could this be the reason why it's not reading the files to be attached? When I look back at how it was concatenated in the Summary tool, the output has the two backslashes after the semicolon separator.  

 

A_Harkleroad_2-1753384988544.png

 

I appreciate any suggestions. 

 

Thank you. 

 

2 REPLIES 2
binuacs
21 - Polaris

@A_Harkleroad For multiple email attachments, use batch macro, sample workflow attached

binuacs_0-1753394589174.png

 

A_Harkleroad
5 - Atom

@binuacs Thank you so much! This solution worked for me.

Labels
Top Solution Authors