Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending email when a cell equals certain value
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending email when a cell equals certain value
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
sending email based on cell condition | Excel Discussion (Misc queries) | |||
Hyperlinks to Specific Cell Fails After Sending Email | Excel Discussion (Misc queries) | |||
If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
Excel spreadsheet sending email based on cell formula | Excel Worksheet Functions |