software

This will sound like a silly question, but I would like to know if it can be
done just the same.

I don't know enough about Excel and whether it is integrated into MS Outlook
this way, but is there any way - based upon a date value in a spreadsheet,
that i can have it send someone else a MS outlook email automatically upon
opening a file.

Here is what I would like to to:

I would have a spreadsheet that would auto track the system date in a cell -
using =NOW( ) function. I would also be tracking expiry dates of various
products - one per row - in a date column. I would determine a date value in
a second quot;order nowquot; column that if product renewal date - sys date =0 - pls
send an email alert to a predetermined contact (even if it did not have a
message included).

is there anyway this can be done with existing Excel functionality - or with
onboard macro logic (maybe an autostart macro that would check the quot;order
nowquot; date value column and if it found any value = 0, it would complete the
macro by doing a file/send to/mail recipient). Or would this kind of
integration require advanced visual basic skills?