I'm trying to send an email in SAS with an excel file attachment. As written, I get no errors but I do not receive the email at all. If I comment out the ATTACH statement, then the email does send, obviously without the attachment, I just receive the body of the email. SAS is installed on a Linux server, I'm using SAS EG on a virtual windows desktop. I have had no problems sending image attachments of charts and graphs with similar code. Can anyone see a reason why I'm not receiving my email in this case?
options emailhost=smtp.test.test.test;
filename mailbox email ('test@mail.test')
attach=("/directory/file.xlsx" content_type="application/vnd.ms-excel")
subject = "Email Subject" content_type="text/html";
ods listing close;
ods html body=mailbox;
data _null_;
file print;
put "This is an automated email. Please do not reply";
run;
ods html close
An Excel content type of
content_type="application/xlsx"
is more usual but I'm not sure if that will fix the sending issue.
Is the .xlsx small enough to not exceed some limit for attachments?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.