abhas (12/4/2012)

---

Hi Jeet,

I want to use this by using SSIS.

Thanks
Abaso jadhav

abhas (12/5/2012)

---

Hi rhythm

I am doing the same but emails are going repeatedly.
Example if there are 5 students then 5 different mails are going.

Thanks
Abhas.

abhas (12/5/2012)

---

Hi rhythm,

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;

Dear Sir,
student1,student2,student3 are absent today.Please take required action.


Thanks
Abaso Jadhav