Automatically send outlook reminder email when a due date is over 30 days past due in excel

[fiorellad3]

Hello,

In Excel I have a list of data. This data has column J which is the due date column. Also, I have column S which is the email column for the email recipients, then column T which is the reminder1 column subject line "Customer's facility due date is past due over 30 days and in column U we have the reminder2 with has subject line "Customer's facility due date is coming up"

Basically we need 2 macros bottom emails. 1 macro to send emails reminders when the customers facility due date is past due over 30 days and a 2 macro to send emails reminders when the customers facility is coming up in 30 days. For this keep in mind that column J (due date) has dates in 2020 and also in 2021. Can you help me create the vba code ? Let me know if you need additional information.

Thanks,

fiorellad3

 

[severynm]

Very similar question here: VBA/Macros to send outlook email notification from excel