topic Re: Why SAS email attachment works for CSV file but not xlsx? in ODS and Base Reporting

Why SAS email attachment works for CSV file but not xlsx?

Eusuee — Tue, 10 Mar 2015 22:07:54 GMT

Yesterday I tried to attach a file in email via SAS the first time, but the weird thing was, it worked fine if I attached the CSV file, but if I tried to attach a xlsx file, the attachment in email couldn't be opened.

I then clicked on the attached file, it said "Excel found unreadable content in "filename.xlsx". Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes."

Then I clicked on yes, it showed another error message "Excel cannot open the file "filename.xlsx" because the file format or the file extension is not valid. Verify that the file has not been corrupted and the the file extension matches the format of the file."

I checked the xlsx file, it looked all good and could be opened on local computer without question. Does anybody know what could cause the issue? Thanks!

filename outmail email 'xxxx@xxxxxx.COM'

subject="xxxxxxxxxxxxx"

attach="/xxx/xxxx/xxxx.xlsx";

Re: Why SAS email attachment works for CSV file but not xlsx?

ballardw — Tue, 10 Mar 2015 22:15:16 GMT

The issue may be with how the xlsx file was created. If created in SAS provide example code.

Re: Why SAS email attachment works for CSV file but not xlsx?

Eusuee — Tue, 10 Mar 2015 22:22:57 GMT

proc export data=outlib.test outfile="test.xlsx"

dbms=xlsx replace;

sheet="Data";

run;

Re: Why SAS email attachment works for CSV file but not xlsx?

SASKiwi — Tue, 10 Mar 2015 22:25:49 GMT

With Excel you need to add this to your FILENAME:

content_type="application/xlsx"

Re: Why SAS email attachment works for CSV file but not xlsx?

Eusuee — Tue, 10 Mar 2015 22:36:00 GMT

Thanks SASKiwi. I added content_type as you suggested but failed with the same error again.

Re: Why SAS email attachment works for CSV file but not xlsx?

SASKiwi — Mon, 10 Jul 2017 23:38:26 GMT

Try this, perhaps ordering is required. This works for me.

attach=("Spreadsheet.xlsx"  content_type="application/xlsx")

If sending multiple files, specify the content type for each attachment. Example:

attach=("Spreadsheet1.xlsx"  content_type="application/xlsx" 
"Spreadsheet2.xlsx"  content_type="application/xlsx" 
"Spreadsheet3.xlsx"  content_type="application/xlsx" 
"Spreadsheet4.xlsx"  content_type="application/xlsx")

Re: Why SAS email attachment works for CSV file but not xlsx?

Eusuee — Tue, 10 Mar 2015 23:10:52 GMT

Yeah it works now!!! So excited! Thanks a million SASKiwi!

Re: Why SAS email attachment works for CSV file but not xlsx?

mg02492 — Fri, 04 Dec 2015 13:46:44 GMT

Thank you SO much. Just used this with a file created with the new ODS excel destination.

Re: Why SAS email attachment works for CSV file but not xlsx?

pathanfahim1986 — Wed, 06 Jan 2016 21:38:05 GMT

Hi , I had a same problem. And took long time around this. With above solution. It is working fine. Thanks you very much. Fahim

Re: Why SAS email attachment works for CSV file but not xlsx?

brulard — Tue, 16 May 2017 12:12:36 GMT

Experienced the same problem and this solved for it. Thanks!

Re: Why SAS email attachment works for CSV file but not xlsx?

mkeintz — Thu, 18 May 2017 01:15:07 GMT

Because of @brulard's recent reply to this topic, it showed up on recent activity.

@Eusuee. If you are still around, why not mark this topic as solved?

Re: Why SAS email attachment works for CSV file but not xlsx?

SuryaKiran — Mon, 10 Jul 2017 21:10:13 GMT

Thanks @SASKiwi

This solved my problem. I was sending some xlsx files to sharepoint by email and encountered with this problem. In my case I have several files to attach, so it worked for me only if I have content_type="application/xlsx" next to all the files.

Like this:

attach=("Spreadsheet1.xlsx" content_type="application/xlsx" "Spreadsheet2.xlsx" content_type="application/xlsx" "Spreadsheet3.xlsx" content_type="application/xlsx" "Spreadsheet4.xlsx" content_type="application/xlsx")

Re: Why SAS email attachment works for CSV file but not xlsx?

SASKiwi — Mon, 10 Jul 2017 22:26:22 GMT

Wow! Good to see this tip has helped so many.