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

    Suresh

      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