topic Email Attachment not working in SAS Programming

Email Attachment not working

Ujjawal — Mon, 25 May 2015 20:37:13 GMT

The following works perfectly except it is not attaching excel file. When this code runs, it is sending email notification but no attachment in the email notification. I tried the different file and format (txt) for attachment but still not working.

FILENAME OUTBOX EMAIL;

DATA _NULL_;

FILE OUTBOX

SUBJECT = "Status : Macro"

FROM = "abc@gmail.com"

TYPE = 'TEXT/PLAIN'

TO = ("abc@gmail.com")

ATTACH= ("/user/ujjawal/file1.xlsx");

PUT "Check logfile to see whether there is any error";

RUN;

Re: Email Attachment not working

Cynthia_sas — Mon, 25 May 2015 20:46:10 GMT

Hi:

The location of the attachment must be available to the e-mail server. This is something that you need to check with your email administrators.

cynthia

Re: Email Attachment not working

sbb — Mon, 25 May 2015 22:05:49 GMT

Interesting - for both SAS Windows and SAS z/OS (IBM mainframe), I use a remote "SMTP mail server" although my ATTACH=(....) file is local to the system where SAS is executing. Does that jive with your experience, Cynthia?

Scott Barry

SBBWorks, Inc.

Re: Email Attachment not working

Cynthia_sas — Tue, 26 May 2015 00:04:29 GMT

Ah, I don't use a remote SMTP server. I suppose it is possible for it to work differently...About ATTACHE=, the doc says only that "The physical name is the name that is recognized by the operating environment."

cynthia