Tech Support Guy banner
Status
Not open for further replies.

Set email reminder based on conditions on Excel

1K views 8 replies 6 participants last post by  Zack Barresse 
#1 ·
I have a list of jobs (jobs schedule) to do... and they are required to be done in a by certain different dates regularly.

I have a specific jobs date for each task held in a colu. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

Another question - I have a basic dashboard when a job is overdue I want the cell to flash RED

thanks
 
#5 ·
Whether you run a macro (which you will have to run to make it happen, but you can arrange to have it run every time you open the spreadsheet) or just use VBA, you will nonetheless have to open the spreadsheet in order to call the function - code only executes when it is called, and that can't happen unless the spreadsheet is open.
As for your second question, see this link:
http://www.mrexcel.com/tip054.shtml
 
#9 ·
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top