Trying to send an email with a table and an attachment

Question

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

workflow.PNG

AbhilashR · Accepted Answer

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.