Please Review VBA - Having trouble auto sending email reminder from excel!

Hey guys, I have an excel file with VBA that is supposed to create an email reminder on the day that a project is due. The date is in column A and the PM or Project Managers name is in Column F. For example, on sheet 'Sept 2012', project 196 is due on 9/20/12 and Allen has been assigned to the sheet. However, the email is not being automatically created when the workbook is opened. Could you guys please look at it and let me know where I am having problems?!? (this was originally created in this thread http://www.excelforum.com/excel-prog...ease-help.html

The file containing the code that I used is right here! Project Due Reminder ver 1.xls

Guys, anyone?!?!