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;
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
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.
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.