The problem has been solved. Just need to point out content type: attach=("/xxxx/xxxx/xxxxxxxxx.xlsx"  content_type="application/xlsx") ... View more

Type: specifies the content type for the message body. If you do not specify any content type, SAS tries to determine the correct content type. You must enclose the value in quotation marks type='content/type' The default value of this parameter is ‘text/plain’.   Can anyone tell me what is the list of "content/type"? thanks ... View more

no error info in log file, but When I tried to open attached file, it said "we found a problem with some content in the excel file." ... View more

***to generate excel file***; ods excel file="/pro/temp/list.xlsx" style=f304temp startpage=yes bodytitle; proc report data=list_csv nowd split='*' headline headskip style(header)=[font_size=10pt font_weight=bold] style(column)=[just=center cellwidth=0.7in]; column ("Center" ccn)("PID" pid) ("Code" ac); define ccn / display " " style=[just=left cellwidth=1.7in]; define pid/ display " "; define ac/ display " " style=[cellwidth=0.6in]; run; ods excel close;   *** to email out the excel file***; %macro mail7 (dy=2); %if &ndy = &dy %then %do;   data _null_; file mailout; put " "; put " "; filename mailout email  from=('shes@yahoo.com') to=('par@yahoo.com')  subject="List of Patients &tdate" attach=("/pro/94/list_&mdy..xlsx") ; run ; %end; %mend mail7; ... View more