Use macro to send Email when item is past due

[calof1]

Hi,

I have an excel spreadsheet which shows items due date. I wish to send a follow up email when the due date is set. How can i use a macro in excel to send the email to the client, and record that a follow up has been sent.

Can someone please help.

Many thanks,

[#2 · Accepted solution]

@calof1 -

https://excelribbon.tips.net/T000474_Sending_an_E-mail_when_a_Due_Date_is_Reached.html provides a solution.

I would also suggest taking a look at Microsoft Flow as a possible solution https://www.howtoexcel.org/general/sending-emails-from-excel/. 

[#3]

Hi@ChrisMendoza 

Thanks for the information, i will explore the macro over the weekend.

Thanks for your help, much appreciated.