I am doing below steps.
1) Execute sql task - here I am fetching studid,studname,deptname,HodName,HodMail.
2) I am using foreach loop
3) In foreach loop I am using script task and sendmail task
In script task I am fetching mailid's and writting body of message. But what happens in this case suppose there are 3 students belongs to physics dept then 3 separate mails are going to HOD.
I want to send single mail for three students as;
student1,student2,student3 are absent today.Please take required action.