Hey all- just signed up and first time poster. I am a novice to VBA, and don't have access to the file I'm asking about b/c I'm at home. Here is what I'm looking to do.
I have a workbook that lists employees driver license, insurance, and DOT expiration dates (columns). I have columns next to these which default to "no" if not expired and "yes" if expired. How can I set up to automatically send an email notification when any cell in a given range contains "yes"? I understand I may have to use the Windows Scheduler to open the excel workbook once a day/week/etc., to check the values so the workbook doesn't always have to be open.
1. What would the macro be to check a given range to see if any contain "yes"?
2. How can that macro automatically start once the workbook has opened?
3. What is the VBA code to automatically send an email notification if the above macro returns "yes"?
I can upload the file tomorrow if this would be easier to diagnose. I don't really use excel all that much for my job, but I'm trying to layer my knowledge so I can find ways to utilize it more on a daily basis. Thanks in advance for your help!!
Rob
I have a workbook that lists employees driver license, insurance, and DOT expiration dates (columns). I have columns next to these which default to "no" if not expired and "yes" if expired. How can I set up to automatically send an email notification when any cell in a given range contains "yes"? I understand I may have to use the Windows Scheduler to open the excel workbook once a day/week/etc., to check the values so the workbook doesn't always have to be open.
1. What would the macro be to check a given range to see if any contain "yes"?
2. How can that macro automatically start once the workbook has opened?
3. What is the VBA code to automatically send an email notification if the above macro returns "yes"?
I can upload the file tomorrow if this would be easier to diagnose. I don't really use excel all that much for my job, but I'm trying to layer my knowledge so I can find ways to utilize it more on a daily basis. Thanks in advance for your help!!
Rob