AnsweredAssumed Answered

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

Question asked by Suresh on Oct 22, 2016
Latest reply on Oct 22, 2016 by 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

Outcomes