macro to automatically send email when due date approaches in XL spreadsheet.

Hi Guys,
I am a total novice so please reply in the simplist terms.
I have a spreadsheet that I would like a macro or VBA (I think) to generate an automatic email 30 days prior to a cell date being reached.
The column that holds the dates (K) already has a formula that changes the colour depending how close the date is and I am unsure as to how that will effect things.

Column A will hold the recipients email address whilst I would need the info in Coloumn C to be included into the subject line ie Row 3 of the attached spreadsheet would generate:

to: A3[
Subject: a school (C3)

Hi
Just a quick email to alert you that (C3) is due a Review in 30 days.

Kind regards

The actual workbook has six seperate "Tabs" which would all need the same code.

Any assistance is hugely appreciated