Email once date reached on spreadsheet

**djfatboyfats** · 03-21-2008, 08:34 AM

I dont know if this can be done, i have had a request from someone who has asked can excel send a email to outlook once a certain date has been reached on his excel spread sheet.

Example:

Spreadsheet date 21/03/08
Todays date 21/03/08

Email sent to outlook stating something like, "You have a case due today"

Very much doubt this can be done.

Thanks in advance

DJ

**oldchippy** · 03-21-2008, 12:22 PM

Hi DJ,

You'll find one here - see Mail a small message - haven't tried it myself but hopyfully it works

http://www.rondebruin.nl/sendmail.htm

**Rick_Stanich** · 03-21-2008, 12:54 PM

Not knowing where the Date value is stored on your worksheet, I assumed Cell "A1".
This code should get you started, if the date in cell "A1" is equal to today (the current date) (Now) it will process an email. The user will be prompted to enter an email address. If the date in cell "A1" is older than today the user will be prompted with a message box that the date has expired also showing the date in cell "A1" and the current date (Now).

Please Login or Register  to view this content.

Ref: oldchippy
I believe the above code is from Rons site

**djfatboyfats** · 03-25-2008, 02:24 PM

This is good, but i want it to automatically send me and email to my email address not for me to enter an email adress for me to send it to.

Can we do that?

**Rick_Stanich** · 03-26-2008, 10:21 AM

Yes you can!

All you need to do is alter one line of code (I do not know your email address).

sRecipient = "[email protected]"
Change the email address in the line above to your actual email address, do not change any other text in the string, the quotes are required.

Please Login or Register  to view this content.

**arnab0711** · 09-11-2008, 12:58 PM

Hi All,
Other than sending a message to particular person can we send a specific file,on a specific date and also to multiple people.

**oldchippy** · 09-12-2008, 05:14 AM

Hi arnab0711,

Please read the rules (especially rule 2) and post a new thread

**froggystyle** · 09-13-2008, 10:47 AM

Hi, I am looking for this type if thing, i would like a mail to be sent when a cell hits a value, is this possible?

Thanks

Email once date reached on spreadsheet

LinkBack

Thread Tools

Rate This Thread

Display

Email once date reached on spreadsheet

Email once date reached on spreadsheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions