Hello All,
Here is the image of my excel sheet, i need to send mails to absent employees all at once .i have used foreach loop but it is sending mail to each employee separately . i need to send all at once with there names .
Thanks
Pranay
You can add their email ids in To by ; separated
Say
Abc@pqr.com;pqr@lmn.com
am using foreach loop and storing all the absent employees in a string .how to send mail to all those emails from that string
Use that send email out of for each Row
First add those emails in a variable by ; separated
@ImPratham45
can u please provide me with that logic .
When u use filter datatable for Absent
List=New List(Of String)
Then use For Each row
In that use
Add To Collection
In that add that EmployeeName
after for each row
Use assign
Var string= String.Join(“;”,list)
Then use Send Mail Activity In to add This Var variable
Thank You @ImPratham45
Your Welcome!
Happy Automation!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
