VBA code for an alert when cell reaches some date

[Rato do Porão]

Dear all,

I have a excel file with some deadlines and tasks. What i'm looking for is a vba code or formula to alert me which task is available for the day, when i arrive to the office. Also, I'm trying to, in some tasks, send a email with the fields "To", "Cc", "Subject" and "Text/message body" from a table.

To start: Can I put it all in one sheet? Or I have to split the tasks witch I need to sen a email to another sheet?

The file:
In column A - I have the task name
In column B - I have the Deadline as a date (with a IFERROR(VLOOKUP to search the correct date based on the condition on column C and a table in second sheet. This is a monthly calendar, so I have to change the range every month)
In column C,D,E,F,G - I have complementary information (could be in alert, but isn't necessary) or blanks
In column H - I have the email addresses for "To" or blanks
In column I - I have the email addresses for "Cc" or blanks
In column J - I have the email subject or blanks
In column K - I have the email Text or blanks

Many Thanks in advance for your support