Sending email when a cell equals certain value

[Jorge E. Jaramillo]

I use a spreadsheet to keep control of some documents that need to be
provided before a commercial relationship is established with a customer like
chamber of commerce registration, copy of the Legal Representative's Id,
signature of the Legal Representative, fingerprint, etc. Each one is a
separate column and when all of them are complete, there is another column
that says OK.



What I need is that when that cell changes to OK, Lotus Notes (our corporate
Email client) to automatically create an email message with the Subject
"Documentation Completed". Emails are usually sent to the same people so the
adresses could be automatically added to the address field, but this is not
strictly necessary.

Could someone please tell me how do I do this? I have researched and in some
pages they show some code but my VBA knowledge is very rusted so if code is
necessary (opposite to using just a simple macro), please be specific as to
how to add the code after hitting Alt F11 to open the VB editor.

Thanks in advance.

 

[Jorge E. Jaramillo]

Just wanted to clarify that I don't need the email to be actually sent. All I
need is to summon whatever email client is defined as default and have a
"new" email prepared on that application with a Subject title and a
destination on its "To" field.

The actual action of sending the email, needs to be done manually by adding
some text to the body of the message and hiting the send button.