How to Send multiples mails

Hello All,

            How to send multiple  mails  by extracting mail id's from excel sheet based on if one of the excel columns data matches with the condition (like if multiple employees are absent they should get  mail)


Can u share sample excel file?
or can clear the requirement


if certain employee is absent today .then he/she should get mail

So u can use Read Range then
Use Filter Datatable for ToDays date column say column name= Date.Now.Tostring("dd-MM-yyyy) = A and store it in DT2
Then Use For each Row
Use Send mail activity

1 Like

yeah i have done those steps but stuck near email, how to get email column data to send mail if certain person is absent

As in DT2 you will get filtered data for Absent persons
Then in for each use send mail
In to use Row("EmployeeEmail).Tostring


@ImPratham45 Thank You Man.

Welcome!! :blush:

Happy Automation!!

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