Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Sending Mail on a Condition in Apex 5.1.0.00.45 (Apex 5.1.0.00.45)
Sending Mail on a Condition in Apex 5.1.0.00.45 [message #665865] Wed, 27 September 2017 04:57 Go to previous message
JanCoetzee
Messages: 8
Registered: September 2017
Junior Member
Hi

Don't know if this is the right area but correct me if I should post it in a different area.

I am very new to Apex and am having huge difficulty in doing the following:

I have a END_DATE column in a table. I need to let the users know 60 days and 30 days before this end date is reached. They want to be notified by email and all of this has to be done through Apex.
The page showing the complete data of the table that contains the END_DATE has been created and is working fine. But now to create the function that checks the END_DATE continuously and sent out the mails when the date falls in the 60 day category and in the 30 day category is flooring me.

I am desperate!

Please can someone help?

Regards
Jan
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Passing encoded url string containing %3A (colon) truncates everting after the last %3A
Next Topic: Field replacement
Goto Forum:
  


Current Time: Wed Apr 24 04:35:39 CDT 2024