Hi I am using TDP 4.2 and trying to create an automation. It consist of an Export activity followed with a Set Variable and Send Email activity. Export activity fetches data to an XLSM file and then there is a macro that fires up and create an XLSX file with Current date as Suffix. Now during the send email acitivity I want to pick that most recent file but since name of the file changes because of Suffix I can not pick that file. I can use variable for subject line of the email, but not as an attachement.
I have to eventually publish this script on TIC.