Send email when due date near

[Dannynijp]

Dear All,

At work we order stock from the factory for orders we have from customers, so we set a Date Of Delivery so we know when to input this order in our system.
What I want to achieve is that via a VBA code is to check the "Date Of Delivery" and send out an email to myself 7 days before the due date, stating in Subject that "Order Due date is near" and mention the Order number in the text field. (see below example of excel)

[TABLE="width: 486"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Customer [/TD]
[TD]Order number [/TD]
[TD]Date of Delivery [/TD]
[/TR]
[TR]
[TD]NHMR[/TD]
[TD]89572[/TD]
[TD]13-7-2018[/TD]
[/TR]
[TR]
[TD]NHMR[/TD]
[TD]89354[/TD]
[TD]7-6-2018[/TD]
[/TR]
[TR]
[TD]NHMR[/TD]
[TD]89475[/TD]
[TD]6-5-2018[/TD]
[/TR]
</tbody>[/TABLE]

I am a novice in VBA at the moment and was wondering if somebody could help me out.

Thanks in advanced

 

[daverunt]

I did something similar a while ago. Have a look at that post including the 2 links and see if you can modify those to suite.

https://www.mrexcel.com/forum/excel...d-email-via-outlook-based-excel-due-date.html

 

[Dannynijp]

Thanks Dave for your help, will check if i can get it to work.