ADDDIRE
> -------- Original Message --------
> Subject: RE: Excel Question
> From: "Dwayne Allison" <Dwayne.Allison@xxxxxxxxx>
> Date: Thu, September 23, 2004 8:44 am
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
>
> Add the user to the list
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Suresh Moda
> Sent: Thursday, September 23, 2004 3:28 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Excel Question
>
>
> Hi Mike,
>
> I have tried this program but when using the command CPYTOPCD I am getting
> the error as "User not enrolled in system distribution directory. " What I
> need to do to use this command. Pls, guide me.
>
> Regards
>
> Suresh
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Condon, Mike
> Sent: Wednesday, September 22, 2004 8:40 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Excel Question
>
>
> Have you tried something like this:
> PGM
> CLRPFM FILE(<library>/<datafile>)
> CLRPFM FILE(<library>/<csvfile>)
> RUNQRY QRY(<library>/<datafile>) OUTTYPE(*OUTFILE) +
> OUTFORM(*DETAIL) PRTDFN(*NO) FORMSIZE(255 +
> 133) OUTFILE(<library>/<datafile> *FIRST +
> *RPLFILE)
> CPYTOIMPF FROMFILE(<library>/<datafile>) +
> TOFILE(<library>/<csvfile>) MBROPT(*ADD)
> CPYTOPCD FROMFILE(<library>/<csvfile>) TOFLR(OPER) +
> TODOC(<csvfile>.CSV) REPLACE(*YES)
> SNDDST TYPE(*DOC) +
> TOINTNET(('someone@xxxxxxxxxxxxx') +
> ('someone@xxxxxxxxxxxxx')) DSTD('List of +
> data.') MSG('List of +
> data.') +
> DOCFILE(*NONE) DOC(<csvfile>.CSV) FLR(OPER)
> ENDPGM
> -----Original Message-----
> From: Muralidhar Narayana [mailto:Muralidhar_Narayana@xxxxxxxxxxx]
> Sent: Wednesday, September 22, 2004 9:58 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Excel Question
>
>
> I ve frequently seen users ask for reports to be delivered in "excel
> format". How is this done? My first instinct is to modify my
> report-generating program to output information to an externally-described
> physical file instead of (or in addition to) to a spool file, then to use
> EMAIL to send the physical file to the user with parameter DELIMITER(*CSV).
> But the resulting .CSV file doesn't really look like the report as I drop
> all headings line (including column headings) and total lines. Is there a
> way to deliver the report in "excel format" that actually looks like the
> original report?
>
> Thanks for your responses! Kindly respond
>
>
>
> Regards,
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
