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.
When you press the file attachment from the email activity it does not show you the fill with the date suffix. The suffix is generated at runtime, so will change. The attachment editor knows what activity is generating the file and will in fact pick up the correct file. Give it a try using the date suffix that includes seconds so you get some confidence in this.
You would need to add that manually to the attachment editor. Hopefully the file name is the same. There is a browse button at the bottom of the attachment editor to attach any files that were not made by automation activity.