topic Re: Sending email via SAS with .xlsx attachment in SAS Enterprise Guide

Sending email via SAS with .xlsx attachment

holcoje — Mon, 21 Oct 2019 17:01:35 GMT

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

Re: Sending email via SAS with .xlsx attachment

SASKiwi — Mon, 21 Oct 2019 19:41:07 GMT

An Excel content type of

content_type="application/xlsx"

is more usual but I'm not sure if that will fix the sending issue.

Re: Sending email via SAS with .xlsx attachment

Patrick — Mon, 21 Oct 2019 20:45:07 GMT

Is the .xlsx small enough to not exceed some limit for attachments?

Re: Sending email via SAS with .xlsx attachment

tomrvincent — Fri, 13 Dec 2019 16:52:19 GMT

attach=
(
"foobar.xlsx" content_type="application/xlsx" lrecl=32000
)