formatting in email

[#1]

Hi,

In alert option i am sending a field in mail on reload. the field is nothing but concatination of different fields like concat(name, & date, &product, & product id) as field. in mail that particular field is coming in list form. i want all the values should come in different row.

Ex-    name, date, year, product,product id,name,date

         year,product,product id, name,date,product....            it is comming likewise.

i want it like

name,date,product,product id

name,date,product,product id

name,date,product,product id

note: all above field contain some numerical values.

[francoiscave]

Hi Piyush,

It's something like this:

&chr(10)&

Concat(DISTINCT{<Field_Conditionf={'value'}>}name&' , '&Date&' , '&product,','&chr(10))

&chr(10)& ''&

François

[#3]

Hi Cave,

I am trying chr(9) and the field is coming half in list form and half in tabular form.

Ex

name,date,product, product id,name,date,

product,product id,

name,date,product,product id,

name,date,product,product id,

like wise. half of the mail is formatted and half is not formatted.