Trying to send an email with a table and an attachment

[jennydavis]

Ok- I have the whole workflow built and figured out how to get the tables with high level details but I can't seem to figure out how to attach the report as well. I realize I could run the workflow and pick up the file in the email tool, but the report has a date stamp each time it runs... anyone? I have looked everywhere I can think of but I can't figure it out

[AbhilashR · Accepted solution]

Hi @jennydavis, referring to my attached workflow, I would suggest constructing the output file path inside a formula tool, which gets passed to the render tool and also email tool. That way you know the exact file name and can pass it to the email tool to go pickup the file.  Hope this helps.

[jennydavis]

Hey @abhilashR!

Thank you so much! I had considered a formula, but I could not figure out where to put it! You Rock!!

Thanks

Jenny