I have a tricky issue and need help on this.
I have a excel sheet that contains formulas that produces live formulas through bloomberg. I am trying to automate a process where I copy the values on a sheet and paste it onto a Outlook web browser to send emails at regular intervals. I am unable to install the outlook application onto the computer, thus the outlook.application in VBA is not viable. I am trying to automate using VBS Script so that it produces as follows:
Open excel and refresh to get updated values > Copy and paste values > enter the outlook website with a username and password wall (Possibly using sendkeys) > Create a new email and send at regular intervals (Probably using Task Scheduler for this)
Not sure if this is even possible, as I have tried many ways including running VBA script but none would allow me to do it onto the WEB BROWSER. Hopefully someone can advice this for me thanks