I robotized the excel extraction every day, but the tool that I used extract the file with similar name.
e.g. yesterday uploaded abcd_20200928112, today upladed abcd_20200928666.
how I can send by mail regularly with this attach?
- Either you fetch the file name when you are downloading the file.
- Otherwise, you can create the folder structure like this.
As its your daily BOT, so i will create folder in the starting like this 29Sep2020, inside that i will download my file, now i already know that this folder will contain only one file, so i can easily fetch. Next day folder name will be 30Sep2020. Thats how it works