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