How to send bulk outlook mails

[pranay.a]

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

[ImPratham45 (Prathamesh Patil)]

You can add their email ids in To by ; separated
Say
Abc@pqr.com;pqr@lmn.com

[pranay.a]

@ImPratham45

am using foreach loop and storing all the absent employees in a string .how to send mail to all those emails from that string

[ImPratham45 (Prathamesh Patil)]

Use that send email out of for each Row
First add those emails in a variable by ; separated

[pranay.a]

@ImPratham45
can u please provide me with that logic .

[ImPratham45 (Prathamesh Patil)]

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

[pranay.a]

Thank You @ImPratham45

[ImPratham45 (Prathamesh Patil)]

Your Welcome!

Happy Automation!