How to set an automation to recognize and send an export file with new or different filename due (4289882)

I set Toad for Data Analysts to export new data into a new excel file that a date time stamp on the file name. How do I set TDA to recognize the new file name (refers to the new data/time stamp) that is generated each time the export is done?

Our script truncates a table, gets new data, enter it in a new table, do an export on that new table, they we add the date stamp suffix, and we need TDA to automate the sending of that file (with a new / different filename due to the date time stamp) out as an email.