i need sending mail particular employee mail id and cc tl and manger and total over template send mangaer i have attaced excel sheet plase help me Template.xlsx (11.4 KB)
I need sending mail particular employee mail id and cc tl and manger and total over template send mangaer
Read the excel file, then use for each row to iterate the datatable, and in for each, use mail sending activity (eg. Send Outllook mail) and pass values to it from row("").tostring .
Hi Thanks for update , Can you plz share test report , it’s help lot
Please find the flow:
Note: I was pretty much convinced that you need add one column to data. (just to handling the sent, ‘Yes’ or ‘No’, for this reason I added to your excel file).
In stage 1 you will find:
1.1 Check if param_file exists then read the file and organize data in datatable.
1.2 If param_file not found the flow just will inform you by email and terminate the worklow.
In stage 2 you will find:
2.1 Once you have handled the data, let’s see each row and send the email. So, for each row that has ‘Yes’ for sending email it will send the email.
Put the flow in bellow path: C:\RPA
Your file needs to be located in: “C:\RPA\RPAXX - ReadExcelAndSendEmail” with the name ‘Weekly Performance-Template.xlsx’
If this flow solved your problem, mark as solution
If there any doubt or question, please let me know
RPAXX - ReadExcelAndSendEmail.zip (31.9 KB)
Thanks bro i will check and updated you
I got below error and operation time out also getting error
Ok, in Studio, click Manage Packages and confirm that you have the same:
Let me know: You have the outlook app operational in machine where you try to run the workflow?
If so, let me know if you modify something in flow?
Please check this link, it seems that your 2007 version is not supported: https://docs.uipath.com/activities/docs/about-the-mail-activities-pack
Hi VB_THA thanks for update,
i need more details, manager well get all coders details for mail,plz call me 9704212398
@damodar99 you need Outlook 2010 instead of 2007 in the machine that you want to run the flow, is just that.
Firstable, you need to update the Outlook application.