Tech Support Guy banner
Status
Not open for further replies.

Auto email notifications from Excel, expiration dates

3K views 1 reply 2 participants last post by  Keebellah 
#1 ·
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
 

Attachments

Status
Not open for further replies.
You have insufficient privileges to reply here.
Top