wfishero
08-30-2013, 06:47 AM
Hi,
I'm wanting to know if it's possible to send out an email from Excel based on cell values in an entire column..? I have yet to build the spreadhseet, but here is an idea of what I will be doing:
I will have a large spreadhseet with employee names on it and expiration dates for certain licensing for these employees (CPR license, and other ones). I will make a certain formula to calculate how many days until their license expires in Column F, for example. What I want to do is have the Excel sheet send me an email alert if 1 or more of these employees come within 7 days of being expired (I just ant 1 email total for the day if possible - not 1 email per eployee, but I will go with whatever works).
Also note that the email is not Outlook - it is Novell Groupwise; I don't know if that makes a difference or not.
Thanks,
Wesley
I'm wanting to know if it's possible to send out an email from Excel based on cell values in an entire column..? I have yet to build the spreadhseet, but here is an idea of what I will be doing:
I will have a large spreadhseet with employee names on it and expiration dates for certain licensing for these employees (CPR license, and other ones). I will make a certain formula to calculate how many days until their license expires in Column F, for example. What I want to do is have the Excel sheet send me an email alert if 1 or more of these employees come within 7 days of being expired (I just ant 1 email total for the day if possible - not 1 email per eployee, but I will go with whatever works).
Also note that the email is not Outlook - it is Novell Groupwise; I don't know if that makes a difference or not.
Thanks,
Wesley