Gaurang Mhatre
Member
Dear Friends,
I am maintaining a sheet where there is expected completion date column for which I want to set an alert on email. For e.g. if expected completion of project is 16-Jul-16 then I want to set a reminder on 15th July and 16th July respectively for it.
Also, if the date crosses 16-Jul-16 then too alert should trigger on the email id to the person handling it i.e. person responsible for it keeping his manager in CC. This alert marking cc to manager will go on email only when expected UAT completion date crosses. It should also provide status on mail body of the the UAT which is mentioned in excel last column.
Regards,
Gaurang
I am maintaining a sheet where there is expected completion date column for which I want to set an alert on email. For e.g. if expected completion of project is 16-Jul-16 then I want to set a reminder on 15th July and 16th July respectively for it.
Also, if the date crosses 16-Jul-16 then too alert should trigger on the email id to the person handling it i.e. person responsible for it keeping his manager in CC. This alert marking cc to manager will go on email only when expected UAT completion date crosses. It should also provide status on mail body of the the UAT which is mentioned in excel last column.
Regards,
Gaurang