Use macro to send Email when item is past due

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,

Macro to send email help.xlsm23 KB

ChrisMendoza
Dec 05, 2019
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/.

2 Replies

ChrisMendoza
Iron Contributor
Dec 05, 2019
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/.
- calof1
  Iron Contributor
  Dec 06, 2019
  HiChrisMendoza
  
  Thanks for the information, i will explore the macro over the weekend.
  
  Thanks for your help, much appreciated.

Forum Discussion

Use macro to send Email when item is past due

2 Replies

Resources