- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-21-2019 01:01 PM
(8019 views)
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
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
An Excel content type of
content_type="application/xlsx"
is more usual but I'm not sure if that will fix the sending issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Is the .xlsx small enough to not exceed some limit for attachments?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
attach=
(
"foobar.xlsx" content_type="application/xlsx" lrecl=32000
)
(
"foobar.xlsx" content_type="application/xlsx" lrecl=32000
)