LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
just-curious---george
 
Posts: n/a
Default triggering an email alert from within a spreadsheet based upon a d

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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert an email download from an Excel spreadsheet file Peo Sjoblom Excel Discussion (Misc queries) 0 May 27th 05 09:56 PM
Excel Spreadsheet email attachment unable to open in Outlook Expr. Joanne from Tiffin, Oh Excel Discussion (Misc queries) 1 April 23rd 05 12:21 AM
De-activate the email on my spreadsheet? Rlp Excel Discussion (Misc queries) 1 March 1st 05 06:34 PM
email portion of spreadsheet as attachment Holly K Excel Discussion (Misc queries) 3 December 6th 04 09:37 PM
How do I cancel sending a spreadsheet by email? Cendra Excel Discussion (Misc queries) 3 December 2nd 04 09:55 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"