How I send excel attach by mail regularly when the attach name is similar but not equal?

Help StudioX
1

Hi!
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?
Thanks!

2
  1. Either you fetch the file name when you are downloading the file.
  2. 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