How to send an automatic email from MS Excel if a vaule is true?

I posted this question before but did not get a brief answer for it. I will try to explain the issue. The spreadsheet looks little bit like that: Columns A-G contain various info about customers where column G is called "product sold". Conditional formatting was used to change the cell colour if value in cell G(1,2...etc) is equal to "YES". How can I use VBA and Macros to make the spreadsheet send an e-mail to customer if the product has been sold (if G(1, 2 ...) = YES) ??





I tried to find any tips on web forums but no luck.


If you have any referece (links) I could go to that would be handy too.





Thank you.
How to send an automatic email from MS Excel if a vaule is true?
Example Code for sending mail from Excel


http://www.rondebruin.nl/sendmail.htm





Hope that helps.