Hi there,
I want to send reminder emails to members of staff when certain dates are met. For example i have 3 dates, 1 reminder to be sent after 2 weeks of the first date, second reminder to be sent after 4 weeks of 2nd date and lastly third reminder to be sent after 5 weeks of 3rd date. All 3 dates are on the same row which would all need to be sent to a single staff member whose email i was thinking of having in a specified cell on each row, each row will have different staff members email addresses.
What would be the best way to implement this?
Any help would be much appreciated.
Please let me know if you need me to clarify anything.
Thank you
I want to send reminder emails to members of staff when certain dates are met. For example i have 3 dates, 1 reminder to be sent after 2 weeks of the first date, second reminder to be sent after 4 weeks of 2nd date and lastly third reminder to be sent after 5 weeks of 3rd date. All 3 dates are on the same row which would all need to be sent to a single staff member whose email i was thinking of having in a specified cell on each row, each row will have different staff members email addresses.
What would be the best way to implement this?
Any help would be much appreciated.
Please let me know if you need me to clarify anything.
Thank you