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/

Reply via email to