We regularly email our users with common questions.
I have a table containing two fields - name and html text.
I want to refer to these fields to place the html text into the body of a emails we send to our users.
The html text is not regularly changed, but how do I insert this into emails that are triggered by the system?
I add a drop down box into my email form which shows the name of the html text, but how do I look up the full html text from the field I choose and then place this into the form to send ?
Many thanks,
Piers