Auto e-mail from excel if a cell value is Yes

Hello,

I have a problem and need solution for it., I have a excel worksheet with the data as given below...


Name Student no. Marks Send E-mail to Principal
ABC E34444 75 Yes


There are rows like this. When I say "Yes" to send e-mail to principal, the excel should automatically send a e-mail to principal@abcschool.com with the studen name, no. and marks.


The client used is Lotus Notes


Anybody, please help.'

Thanks in advance

Shaan