Automatic Emailing

I'm trying to build a data base using Excel or Access, where if one cell changes from No to Yes it sends an automatic email to a given email address with only one row of information not the whole document?
And for each row to have different emails etc.
Like a client based system which will inform our clients that their delivery has been sent etc.
If that makes sense?
I have asked Microsoft and they told me to call, which i did and then they ended up hanging the phone up on me.
Ive tried many forums and online tutorials but no one seems to be creating what i want.
Please help if you can!!