J
just-curious---george
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 "order now" 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 "order
now" 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?
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 "order now" 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 "order
now" 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?