Hi Laure,
I used a simple technique for this a while back. Create a program and EXECUTE the retrieve statement and CAPTURE the output. If you add Char(9) to a dict and place this between each field excel will then split it in to columns. EG SORT FILE BY FIELD1 BREAK.ON FIELD1 TAB TOTAL 1 TAB TOTAL 2 DET.SUP Then simply email the output array to the user. If you add html to the array then you can even format the text so it looks better when excel opens it, but this can slow things down as you need to insert table/tr/td into the array. Re andy Legal Disclaimer: The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/