topic Re: Code for sending email displays error despite apparently correct syntax in SAS Enterprise Guide

Code for sending email displays error despite apparently correct syntax

Rohit2RaiAxis — Mon, 09 Nov 2020 09:52:03 GMT

This is the code I wrote

proc export data=work.XYZ
  outfile="XYZ.xlsx"
  dbms=xlsx replace;
run;

filename outbox email
  from='abc@abc.com'
  to='abc@abc.com' 
  type='text/html'
  subject='Test Mail'
  attach=("XYZ.xlsx" content_type="excel");
  
ods html body=outbox rs=none style=Htmlblue;

proc odstext;
  p 'Hello,';
  p ' Please find the attachment';
  p 'Thank You';
  title;
run;
ods html close;

I get error at this line

attach=("XYZ.xlsx" content_type="excel");
                                      _
                                     24

ERROR 24-2: Invalid value for the attach option.

Please let me know what am I missing, or if this is a bug which has a workaround.

Thanks

Re: Code for sending email displays error despite apparently correct syntax

Kurt_Bremser — Mon, 09 Nov 2020 10:00:49 GMT

Try this as the content_type

application/vnd.ms-excel

this is just a quick shot from the hip, not tested in any way.

Re: Code for sending email displays error despite apparently correct syntax

Rohit2RaiAxis — Mon, 09 Nov 2020 10:20:35 GMT

Tried it. Still the same error 🤔

Re: Code for sending email displays error despite apparently correct syntax

andreas_lds — Mon, 09 Nov 2020 11:17:18 GMT

Have a look at https://stackoverflow.com/questions/2937465/what-is-correct-content-type-for-excel-files