Auto Emailing From Excell Based On Cell Date
Closed
Yesraja
-
Apr 15, 2012 at 04:30 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Auto Emailing From Excell Based On Cell Date
- Vba code to send email from excel based on cell value ✓ - Forum - Excel
- How to send email from excel based on cell value - Forum - Excel
- Duplicate rows in excel based on cell value ✓ - Forum - Excel
- How to move rows automatically in excel based on cell value ✓ - Forum - Excel
- Insert image from directory into excel based on cell value - Forum - Excel
1 reply
rizvisa1
Apr 16, 2012 at 02:36 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
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