Most e-mail readers don't display the Carriage return without a line feed. So replace your CHR(13) with CHR(13) + CHR(10).
>G'day,
>
>I have been trying to output a simple list into an email:
>
>PAYROLLID NAME EXPIRY
>========= ============ =============
>1234 TEST 01/12/1999
>
>And so on...
>
>Now - I've been inserting CH(13) (for enter) and so on into a text string that I generate recursively from the table. It looks fine in my edit box preview before I send the message, but once it gets to my inbox all of the tabs and enters have been stripped and it is unreadable.
>
>When I actually type the text into the edit box the tabs and enters seem to come through... I am very confused!
>
>Any ideas? (Email replies would be greatly appreciated)
>
>Thanks,
>Clifton Cunningham
Erik Moore
Clientelligence