I have some information in a excel spread sheet, see attached trial register.xlsm.
I would like to send an email automatically to an address in colum F, this would be sent 30 days before due date in colum D. Information from colums A and B should also be included.

In the case of row 2.
An email would be sent to Adrian 30 days before 31/01/2016 saying Title "FYI" Subject "DMS Serial Number 50308/02 is due EICR on 31/01/2016"

Thank you all in advance