This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am attempting to automate a report, in which four unique .xls tabs have been created, and rolled into one larger .xls file. At this point, I am searching for ideas on how to automate sending this file via email. The tabs need to remain separate in the output, as they have been filtered down to display the same metrics, just different business units.
The issue I am running into is that there is how to set up an email tool with the output in it's current configuration in the workflow. There are four output tools, each sending data to an Excel spreadsheet. Below is how the end of the workflow is set up, but with the Output tool being more or less 'final,' I am having issues trying to link it to the email tool.
My workflow outputs 12 separate Excel files (2-3 worksheets per file). I want to email each individual Excel file to a different audience. In order to name the files "automatically," I've created a NewFileName field which includes some of the file path name and a couple of dynamic fields depending on the filters applied to the specific data set. In the end result, the Excel file created pulls the name of the file from the field NewFileName. I don't want to rename the file manually every month (or week). As such, the Output tool doesn't display the full name of the new files created. How can I choose the path for the attachment from the NewFileName field?