Greetings,

I am creating an EXL2K formatted file, on FOCUS for z/OS, v7.6.4, with the following code:

SET COMPOUND=BYTOC
-RUN
TABLE FILE CAR
"Car Report"
"Country: <COUNTRY"
PRINT SALES
BY    COUNTRY
BY    CAR
ON TABLE HOLD AS CAROUT FORMAT EXL2K
ON TABLE SET STYLE *
 TYPE=HEADING, STYLE=BOLD, COLOR=RED, BACKCOLOR=RGB(255 255 204),$
 TYPE=TITLE,   STYLE=BOLD, COLOR=RED, BACKCOLOR=RGB(255 255 204),$
ENDSTYLE
END

When I FTP the file down to the LAN, and then open it in Excel, I see the content and formatting A-OK.

When I email the file as an attachment, open the attachment in Excel, I see the content, but I do not see the formatting. That is, I do not see the results of the stylesheet commands.

Upon review of the EXL2K file I see CSS code like the following:

.xl102
        {mso-style-parent:style0;
        color:#FF0000;
        font-size:10.0pt;
        font-weight:700;
        font-family:"ARIAL";
        background:#FFFFCC;
        mso-pattern:auto none;
        white-space:normal;
        mso-font-charset:0;}  

In SMTP, the '.' at a beginning of a line is a way to terminate a command.

I MANUALLY EDITED the EXL2K mainframe file and added a period, for every class:

..xl102
        {mso-style-parent:style0;
        color:#FF0000;
        font-size:10.0pt;
        font-weight:700;
        font-family:"ARIAL";
        background:#FFFFCC;
        mso-pattern:auto none;
        white-space:normal;
        mso-font-charset:0;}  

The second '.' acts as an escape for the first one.

I then sent the edited file, through SMTP.

When I opened the EXL2K attachment, I saw the stylesheet results A-OK.

Does anyone know of a workaround for this scenario, or perhaps I am missing something?

I imagine I could post-process the file, but I would prefer not to, if possible.

I have a case open with IB on this scenario, but I thought I would try the Forum as well.

Thanks,
Dave

This message has been edited. Last edited by: Kerry,

Would it be possible to zip it before mailing it? That would effectively prevent the SMTP protocol from interpreting the contents of the file.

You might also change the HOLD to PCHOLD

Pat,

He's on mainframe and therefore has to get the file to his users on Windoze (I guess) so PCHOLD is of no use to him.

T

Good Catch Tony, and totally true. I missed that this was for Z/OS.