How to send bulk outlook mails

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

@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

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

1 Like

@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

2 Likes

Thank You @ImPratham45

Your Welcome!

Happy Automation!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.