5 pts.
 Problems with tranferring flat file from mainframe to Outlook as CSV file
I am trying to e-mail a plain text comma delimited flat file from the mainfram to Outlook. I have the coding working to transfer the file but when the file arrives in outlook the first character on each line is an '&'. When EXCEL trys to open the file it generates an error message that this is an invalid file type for excel to open. Here is the coding I use to transfer the file to Outlook //STEP01 EXEC PGM=IEBGENER //SYSUT1 DD * HELO CSXB1TCP.CSXT.CSX.COM MAIL FROM: <RICHARD_BARNETT@CSX.COM> RCPT TO: <RICHARD_BARNETT@CSX.COM> DATA SUBJECT: LC ADAMS TMMI SPREADSHEET MIME-VERSION: 1.0 CONTENT-DISPOSITION: ATTACHMENT;FILENAME="INSPECTIONS.XLS" CONTENT-TYPE: TEXT/PLAIN /* //* =========================================================* //* FILE TO SEND: // DD DISP=SHR,DSN=A4324.SYSTEM.WIDE.TMMI.YR2008 //* =========================================================* //* DO NOT MODIFY PAST THIS POINT //* // DD * . QUIT //SYSUT2 DD SYSOUT=A,DEST=TCPBSMTP //SYSPRINT DD SYSOUT=* //SYSIN DD DUMMY //* // Here is how the comma delimited file looks on the mainframe: "ASHLAND","MECHANICAL","Y",0,0,0,0,0,0,0,1 "ATKINSON","MECHANICAL","",0,0,1,0,0,0,0,0 Here is how the comma delimited file looks after being sent to Outlook: &"ASHLAND ","MECHANICAL","Y",0,0, 0,0,0,0,0,1 &"ATKINSON ","MECHANICAL"," ",0,0,1, 0,0,0,0,0 What cause the '&' to be inserted on each line? Any help will be greatly aprreciated Thanks in advance Rick Barnett

Software/Hardware used:
ASKED: September 2, 2008  4:59 PM
UPDATED: September 2, 2008  6:17 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _