Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I convert an email download from an Excel spreadsheet file | Excel Discussion (Misc queries) | |||
Excel Spreadsheet email attachment unable to open in Outlook Expr. | Excel Discussion (Misc queries) | |||
De-activate the email on my spreadsheet? | Excel Discussion (Misc queries) | |||
email portion of spreadsheet as attachment | Excel Discussion (Misc queries) | |||
How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) |