I have attached a spreadsheet.
I have code to send an email from lotus notes in Module two.
I would like the email to be automatically sent when either of two events happens
(1) IF N68 (CA Checklist) = "Send Email" at 12.00, then Send Email
(2) IF N69 (CA Checklist) = "Send Email" at 18.00, then Send Email
I put some code in Sheet1 (CA Checklist) for the recipitant and subject.
The password for the project is "protectprocess"
Any suggestions would be great!