Send email automatically before due date

Hi all,

I have a workspread that it is able to send email from a macro. I like to improve it so that it can do the following things:
1) Send an email automaticallywhen it is 30 days before the due target date (column G).
2) Include in the email the row that have the due date item and if possible in the email's subject too.

Is that anyway I can do it?

Attached is my test file on this.

Appreciate any help on this.