Dear all,
I have two columns in my dept heads table ,1 is the location & other is their department head's email id .
Now in my report I have three columns,1 is location & 2nd is task name , & the other is task due date .
now i have written a small program to send a mail if any one of the location is set (filtered), using if else.
but i need a code where it sends a mail to everyone related to the location column say out of 10 location ,i have filtered 4 of them.
then it should send a mail to all the 4 dept heads related .
can any one send me the code pls.