EMAIL device with .xlsx attachments

TS2000 — Fri, 13 Dec 2019 15:55:10 GMT

I use the EMAIL device to send email through SAS from a Linux system. This works just fine in most cases, but when I attach an .xlsx file the file somehow gets corrupted. When I receive the email, everything looks good, but Excel can’t open the attachment. It gives an error message "We found a problem with some content in..." and then "Excel cannot open the file...". I see that the documentation for the EMAIL device has an option CONTENT_TYPE='content_type', but no indication what the possible values are. Is there a particular content type that should be specified? Or is there something else that needs to be done to allow .xlsx files to be attached? I’ve seen a post here from 2013 with the same problem, but no resolution. Below is code used:

filename em

email ("&emailaddr.")

to = ("&emailaddr.")

subject = "Test"

attach = ("/amex2/ramp/misc/gsc_glob/tashelly/ods/GCG_Unique_CM_201911.xlsx")

emailid = "&emailaddr."

;

data _null_;

file em;

put "Test";

run;

Re: EMAIL device with .xlsx attachments

tomrvincent — Fri, 13 Dec 2019 16:50:34 GMT

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

topic EMAIL device with .xlsx attachments in ODS and Base Reporting

EMAIL device with .xlsx attachments

Re: EMAIL device with .xlsx attachments