Can Excel auto send me email?

Hi All,

May I know if below request are possible to done by macro?

System will automatically send me an email when the date listed in "column J" is "EXPIRY". Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Office Outlook 2007.

When the Column J is EXPIRY, it will auto email me below information :-
BU - Column A
Application Date - Column B
Company Name - Column C
PIC - Column I


I have attached here the excel for better understanding.

Hope to hear from u all soon !!!