I have a spreadsheet with a simple if statement to determine an outcome IE "OK" or "DUE". If OK nothing needs to happen but if "DUE" appears I need to send an email with regards to the date, subject and person concerned. 1 kind person has already supplied me with the code need to see if "due"...
I have a spreadsheet with a couple of "if" statements on it and I need a Macro/VBA to trigger sending an email to a prearranged person if the word "DUE" appears on the sheet as a result of the if statements. Is this possible ?