Thank you Nived.
My project is about sending e-mails to different clients about the stock market portfolio they have.
I have 8 different clients with multiple portfolios.
Project is to capture a stock value price from MoneyControl website for each company they have invested in and update an excel. Once the excel is updated I will have send them e-mails with their respective attachments.
To begin with I have broken down the project in 3 components
Uploading the transaction to orchestrator - I have managed to upload only 1 excel and the transaction are reflecting in orchestrator, but I dont know how to upload the rest 7 excels
Data scrapping - This is working fine and data is getting capture however there is one filed where we are not able to capture the data on the website as the cursor is showing horizontal. I have parked that issue for now. Any advise will be great.
Sending e-mails - I have created an excel with client details and their e-mail ids however I can figure out how to create the loop and attach a specific attachment to email.
Let me know if you any clarification.