Hi,
I have a requirement to send 1 file for each month from 2021 to 2022 ( 24 files ) and I want to avoid creating 24 restricted filter for each month and attaching them to the email.
Is there an easier way to automate this process and meet this requirement.
Thanks
Having looked through the forums I think you need all the filepaths for the attachments in one row:
I have attached a workflow that is missing email credentials but makes 24 text files then has a directory tool pointing at them and pivoting to get all the file paths in one go. Then you can hard code the email tool to include all 24 file paths.
For your context make the reports grouped on date so that you create multiple files for each MY combo. Then point a directory tool at all of them pivot and configure the email tool.