Code for sending email displays error despite apparently correct syntax

[Rohit2RaiAxis]

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

[Kurt_Bremser]

Try this as the content_type

application/vnd.ms-excel

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

[Rohit2RaiAxis]

Tried it. Still the same error 🤔

[andreas_lds]

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