Send email notification 4 months earlier before a date is due

Hi, 

Is it possible to send an email notification to several people through Excel sheets, if a cell's date is due 4 months earlier? In the excel sheet I'm keeping information about the contract such as the due date and the concerned persons.

I'm working with contracts and I'd like send email notifications to the concerned persons about this contract to take actions. It is preferred that the notification is sent daily (during the 4 months period) until I turn it off. 

I'm using excel 2013. 


  • Edited by S.Eid Sunday, May 17, 2015 6:20 AM
May 17th, 2015 6:18am

Hi S.Eid,

Based on your description, I dont understand the meaning of send an email notification. If you wonder to set a reminder which remind yourself there is an email with the contents need to be sent. Or if you wonder when you open the workbook it send as attachment automatically and contain the correct receiver with the correct contents.

For my understanding 1, this is easy to get the result with trigger macro in excel. But for another understanding is hard, and you need to provide more information about your needs.

Please be a bit more precise explain your problem so that we can get more accurate solutions to this problem.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
May 18th, 2015 10:33pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics