I have made an application which we use for our dog school. I have a list box with multiple clients (a class)and their e-mail addresses. Now I want to have the e-mail addresses from all clients in that list box (max 8) in a single string with a ; between each e-mail address (for outlook) In this case I can send an e-mail to the whole class. I am using the old Office templates form Softmasters.
My programming skills are not the best, that’s why I am using Clarion
I don’t know these Office templates, but maybe you could try something like that (qEmail is the queue that is linked to the list control):
strBigEmail = ''
loop i=1 to records(qEmail)
strBigEmail = qEmail.strEmail
strBigEmail = clip(strBigEmail) & ';' & clip(qEmail.strEmail)
If using SQL, check out the string aggregate functions.
In PostgreSQL, a simple function handles this for you.
Thanks! It’s working now!