Auto Emailing From Excell Based On Cell Date

Closed
Yesraja - Apr 15, 2012 at 04:30 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 16, 2012 at 02:36 PM
Hello,
I have a new query here!

I want to be able to send an email alert from to an email address based on date criteria:

Example:
Today's Date: 16-April-2012

If "VALID DATE (E - Column) Value < "Todays Date" Then "I need to sent email" for all mention email id's in the "J"

I have attached the my file here, please review -> http://www.4shared.com/office/YBIr8CX6/Due_Date_Email.html

Can you help to find the logic for comparing the date filed with today's date?


Anyone please help me to solve this...

Thanks in advance!!!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 16, 2012 at 02:36 PM
I dont think that function on sheet will help
you would need a macro to trigger the call
some thing like
if ( isdate(range("E1")) then
if (format(range("E1"), "YYYYMMDD") > format(now, "YYYYMMDD")) then
call emailMe()
end if
end if
0