Dynamic email templating in Oracle APEX
hi all,
I have created an application which sends email to all checked students in grid. I have different templates stored in database to send the email, and those templates are displayed in select list, manager first select the multiple checkboxes in student grid, then he selects appropriate template from select list. and click send email button. The application with appropriate template goes to all the checked students. Now i want some of the text in these templates to be dynamic, that means every template will suppose have a
Dear SURNAME FORENAME
I want these to be filled up with the selected checkbox dynamically. Can anyone guide me, what all changes i have to do in my procedure to make it dynamically pick up my selected data and put up in to the template
With Regards,
Sunil Bhatia