substituting words for values in a table or another field
Posted on 2003-11-13
I am trying to generate some code that will replace certain keywords with value from a specific field.
e.g. [Name] placed in a message box would be replaced with the "Name" field from the CUSTOMERS table.
This is for an email script I have.
The text box which the email is written in is called "CommsNotes". It is on a form called "CUSTOMERS email query"
It is quite complicated, as it pulls the values from an SQL query in another form "CUSTOMERS" and puts them into a list box. But I guess that the code I am trying to write could simply substitute the keywords for the values in the columns of the list box.
Does anyone know if this is possible first of all?