My bot is installed in my local system and it needs to download an excel sheet in form of an attachment from outlook(in the local system),then copy the same excel to RDP, extract some data from the excel and use it in writing scripts in MS Powershell.
Is it possible, if yes, then please let me know how!!!
As far as I understand, everything you need should be possible. The steps I identify now are:
- Automate the finding of the e-mail with the required attachment and download it to local disk;
- Copy the file to clipboard;
- Open whichever Remote Desktop Connection utility you use and make sure you have Clipboard Sharing/File Sharing enabled (or maybe you can share the folder with the attachment with the remote server);
- Open the file on the remote server and use keyboard shortcuts / image automation for extracting the data and using it in PowerShell.
Let us know if you need more guidance.