AnsweredAssumed Answered

Creating email with task update

Question asked by mikedc on Oct 21, 2018
Latest reply on Oct 21, 2018 by mikedc


Im trying to set up an email script consisting of 2 related tables, 1 being a client table, 1 being a task table.

I want the email to include all 'open' tasks with its remarks.


f.e. database :



taskfield=this is the task 1 / taskstatus field = 'open'

taskfield:this is the task 2 / taststatus field = 'closed'

taskfield:this is the task 3 / taststatus field = 'open'


f.e. Outcome in email =


You have following open task:


this is the task 1

this is the task 3