Concatenate all Possible field values in one row.

[slondono]

Hi guys

I need to concatenate the possible field values in a table. The field is e-mail (its for an nprinting thing).

so, i need a table with this possible fields concatenated, something like this: 95david@hotmail.es;120@hotmail.com;123@hotmail.com

Im doing this because i need that NPrinting send just 1 email to all people and not 1 email per person.

[sunny_talwar · Accepted solution]

Can you try this:

Concat(DISTINCT Correo, ';')

[slondono]

Excelent, save my life

[Peter_Cammaert]

Note that siooner or later, some MTA has to duplicate the message and send a copy to each individual user. You just don't like NPrinting doing this?