I have two mock-up data files. Data Dump file has all the information required for the email attachment.
Mapping file has details of from, to, subject, attachment password for different entities.
I am looking to create multiple draft emails in outlook. One email for each unique combination of Region, Client Name and Counterparty in Data Dump file.
For example, one email for Region = Belgium, Client Name = Minerva and Counterparty = Nova. Now, there are 3 line items for this combination in Data Dump file. An email has to be created based on the information in mapping file for this Region, Client Name and Counterparty combination. Corresponding columns in Mapping file are Location, Client and Broker for these columns. So, an email has to be created with to as “email@example.com”, cc as “firstname.lastname@example.org”, From as “email@example.com” and Subject as “Belgium-request for statement-as of date-Nova”. Attachment should contain the 3 line items from Data Dump file (columns A-G) and it has to be password protected by password “MhsYjs78”.
Body of the email changes based on Comment in Data Dump file.
Initial Email : Body - Please find attached and provide response
1st Chaser : Body - Following up on the below
2nd Chase: Body - Humble follow-up again on the below.
Is this something which UiPath Studio can do?