Macro to send email upon certain date trigger

[fabrecass]

Hi guys,

I think this is super complicated and i can't get it to work even a little bit...

i need excel to, upon opening a workbook, send an email if a condition is met, that condition being a date in a cell passing ONLY if adjacent cell is blank.

for example, in column A we have a list of dates, and if the date in A2 passes and B2 is blank, i need it to trigger an email sent to one fixed recipient, preferably with the title of the workbook within the body or title of the email.

Can someone help me?

If any more information is needed please ask!

EDIT* thinking about it, this doesn't seem like a macro is needed, perhaps an active function type thing? (forgive the lack of technical jargon)