I need to email daily reports generated in SAP and downloaded to Excel. Downloaded files are opened and formatted using mostly Hot Keys. The files are saved using and replacing the same filename in a folder.
Look at this excel sample file:
Then, if there is a file in Folder XYZ with this filename - then email it to the corresponding email address on excel file. Ignore if no file is found in folder as there are days when there will not be a file for each.
Any and all suggestions with samples would be greatly appreciated. Thanks.