Auto Emailing From Excell Based On Cell Date

Closed
Yesraja - Apr 15, 2012 at 04:30 PM
rizvisa1 Posts 4478 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!!!
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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