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.
View best response
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/.
Thanks for the information, i will explore the macro over the weekend.
Thanks for your help, much appreciated.