Hello, i have the attached spreadsheet where by i am trying to create a code that will send one of two emails when either the due prompt date is reached or the due date is reached. The subject for the prompt date should be 'Task Reminder' and the subject of the due date if reached should be 'Task Due'. the body of the text should simply be the contents of what is in Column a and the 'to' address should be derived from column e with a standard email address added as 'cc' i.e my own email address ("[email protected]"). I am also looking to have the code run each day without me needing to open it each time, but so far think that may only be possible with the use of windows scheduler - unless there are other ways of ensuring its run without me opening?
Any help would be much appreciated