I’m a beginner with UiPath and working on a project.
In my project, it requires me to send different attachment saved in a particular folder to multiple recipients. There are 8 different attachments and 8 different recipients.
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.
You can merge it in one sheet and use for each row activity to perform the data capture.
Once its done you can use email sheet and sort the data using the username and write to a separate excel sheet then you can upload that excel sheet to the particular id.