Regrouping fields in emails
I have a small problem that I will try to explain you. Lets say I have a table called "Groups" and another one called "Names". In "Groups" I have one field called GroupName. In "Names" I have two fields, FirstName and LastName. The two tables a properly linked with a primary key.
I would like to produce an email with a content like the example below :
Group : GroupName1
Thanks in advance for you help in this matter