Hi, I have zero experience with VBA but need to get the attached spreadsheet set up so that an email notification is automatically sent whenever an expiry date is within 30days.
In Sheet 2 (Required Compliance) I have entered the my name as the person to address the emails to, and my email address.
If possible I need to set this rule up for every sheet within the workbook, and for it to also update the Mail Status column to display whether or not notification has been sent.
Can anyone help me to set this up? Thanks in advance
In Sheet 2 (Required Compliance) I have entered the my name as the person to address the emails to, and my email address.
If possible I need to set this rule up for every sheet within the workbook, and for it to also update the Mail Status column to display whether or not notification has been sent.
Can anyone help me to set this up? Thanks in advance