Sending ZIP File in Mail.

Kumaresan.nk · New User Joined: 22 Mar 2010 Posts: 31 Location: Chennai

Hi,

I'm trying to ZIP an excel file and send it in mail. I tried SAS and IEBGENER. But am not able to get the zip file as attachment. Here's the code i used -

SAS Code:

DATA REPORT;
FORMAT DATE1 MMDDYY8.;
CALL SYMPUT ('HDATE',PUT(TODAY(),MMDDYY8.));
FORMAT EMAILDATE MMDDYY8.;
PUT "!EM_SUBJECT!" "HDATE11";
FILENAME MYFILE EMAIL
FROM= ("emailid")
TO= ("emailid")
ATTACH=("*.*.*.ZIP" NAME='NYBROK Report'
EXTENSION='ZIP')
TYPE= "TEXT/PLAIN";
DATA REPORT;
SET REPORT;
FILE MYFILE;
PUT "!EM_SUBJECT!" "NY REPORT";
PUT "Please find attached the NY COMSN REPORT";
PUT "run &HDATE . ";
RUN;

Code Used to ZIP using PKZIP:

-TRANSLATE_TABLE_DATA(EBC#xxxx)
-DATA_DELIMITER(LF)
-FILE_TERMINATOR()
-ARCHIVE_OUTFILE(ZIPOUT)
-ARCHIVE_COMMENT(ZIP FOR DMS)
-ENCRYPTION_METHOD(STANDARD)
-ACTION(ADD)
-INFILE(INFILE)
-ZIPPED_DSN(*,*.*.*)

Code used with IEBGENER:

HELO 'server address'
MAIL FROM: <emailid>
RCPT TO: <emailid>
DATA
FROM: <emailid>
TO: <Kumaresan.Neelakandan@COGNIZANT.COM>
SUBJECT: NY REPORT
MIME-VERSION: 1.0
CONTENT-TYPE: MULTIPART/MIXED;BOUNDARY="MIME"

--MIME
CONTENT-TYPE: APPLICATION/ZIP; CHARSET=US-ASCII
CONTENT-TRANSFER-ENCODING: 7BIT

Hi All,

Attached above is the NY BRoker Commission Report for your
reference.

--MIME
CONTENT-TYPE: APPLICATION/ZIP
CONTENT-DISPOSITION: ATTACHMENT; FILENAME=NYBROK.XLS

My requirement is to zip an excel file and the send it as an email.

superk · Posted: Wed Dec 15, 2010 2:42 pm

TYPE= "TEXT/PLAIN";

Does that seem right to you?

PeterHolland · Posted: Wed Dec 15, 2010 3:27 pm

Following link gives a nice example :

support.sas.com/resources/papers/proceedings10/084-2010.pdf

Robert Sample · Posted: Wed Dec 15, 2010 5:10 pm

If you're going to use SAS, use SAS and follow the example Peter cited -- or better yet look up on the SAS web site the details for yourself. If you're going to use SMTP, use SMTP and get rid of every bit of SAS code you've got. What you have done is mix SMTP and SAS -- which generally becomes a big mess and certainly will not give you what you think it will.

PeterHolland · Posted: Wed Dec 15, 2010 5:23 pm

Robert,

you are totally right, mixing mailing solutions (?) will lead to nothing.
Its the same like mailing part by carrier pigeons AND part by floppy discs.

Robert Sample · Posted: Wed Dec 15, 2010 5:39 pm

Peter: and those carrier pigeons REALLY hate having floppy discs strapped to their legs!

PeterHolland · Posted: Wed Dec 15, 2010 7:59 pm

Robert Sample · Posted: Wed Dec 15, 2010 8:15 pm

Actually, no -- but I like the image of a pigeon flying along with a floppy disk attached to its leg ....

enrico-sorichetti · Posted: Wed Dec 15, 2010 8:45 pm

shall we start speculating on how having additional surface exposed to the air flow
might let pigeons float better by putting less strain on the wings

??

Grant Goodale · Posted: Thu Dec 16, 2010 12:17 am

Enrico -

It might be carried in the same way as a coconut can be carried by swallows. Then the question is - African or European swallows.

Kumaresan.nk · New User Joined: 22 Mar 2010 Posts: 31 Location: Chennai

Hi,

Now, I'm able to get the ZIP file as attachment in mail. But am not able to get the message that is supposed to be displayed in the body of the mail. I used the following SAS code -

DATA REPORT;
FORMAT DATE1 MMDDYY8.;
CALL SYMPUT ('HDATE',PUT(TODAY(),MMDDYY8.));
FORMAT EMAILDATE MMDDYY8.;
PUT "!EM_SUBJECT!" "HDATE11";
FILENAME MYFILE EMAIL
FROM= ("EMAIL-ID")
TO= ("EMAIL-ID")
ATTACH=("TEST.XXX.XXX.REPORT.ZIP" NAME='NY BROKER REPORT'
EXTENSION='ZIP')
TYPE= "APPLICATION/ZIP";
DATA REPORT;
SET REPORT;
FILE MYFILE;
PUT "!EM_SUBJECT!" "XXX NY BROKER COMMISSION REPORT ";
PUT "Attached is the NY BROKER COMMISSION REPORT";
PUT "run &HDATE . ";
RUN;
QUIT;

Can anyone let me know what might be the issue with this, please.