5 Replies Latest reply on Oct 22, 2016 4:36 AM by Suresh

    Find expired date Record values in a Found Set & send that to recipients in one mail


      Good Evening All.


      I have a table with two fields

      1. pk_Task

      2. Target Date


      If Task's target date is expires today means have to find all records & find out the expire target and send one mail to some recipients.


      So in that one mail i required to come as,

           Target Expires Today
           Task : Task 2119 
           Target : 22-Oct-16
           Task : Task 3168
           Target : 22-Oct-16
           Task : Task 3389 
           Target : 22-Oct-16


      So how to make a script for this!


      Help much appreciated!


      - Suresh