Hi all,
How do I save an Output Data with a dynamic file name (FilenameYYYYMMDD.xls), then send it as an attachment to an email?
Hi @RonGatmaitan
Step1: Create the column with full path + filename + sheetname like below
Step2: use a block until done this makes sure file is written first and then mail is sent.
Step3: configure output tool to write file based on column passed as path
Step4: pass the column as path for file to be attached in email tool
Hope this helps : )
Checking this out. Seems pretty simple. Thank you, @atcodedog05!
Hi @atcodedog05,
I most certainly will. 🙂I have 2 more questions, please.
1. Is there a way to hide the FileNameAs sheet from being written to the Excel file? I just realized, since it's a field in the table, it is being written to the Excel file, too.
2. Why is it sending as many records as emails? Did I miss anything out?
Use select tool and remove
Use summarize tool and convert into a single row. 1 mail is sent per row.
I am able to remove the others, except for the FileNamePlusSheet as the Output needs it.
Done! I just unchecked the Keep Field in Output tag. Thank you very much! Marking your answer as the solution now. 🙂
Happy to help : ) @RonGatmaitan Cheers and have a nice day!
THANK YOU VERY MUCH @atcodedog05!
