Multiple email attachments of different types

[Doug____]

I am attempting to use the ATTACH statement in an email with multiple attachments and the following error is returned:

data _null_;
rd = strip(put(&run_date,mmddyyd10.));
call symputx('rd',rd);
run;

filename mymail email "[email protected]";
data _null_;
file mymail
From = ("[email protected]")
To = ([email protected])

subject=(" Reports &rd");
attach=("\\xxx\Reports TOC &rd..xlsx" "\\xxx\REC.xlsx" );

run;

The log returns error 22 (syntax error saying it was expecting another operator and it fails. I also need to send several pdf files in the same email.

[Jagadishkatam · Accepted solution]

could you please try the below syntax of the code to send the attachments, this worked for me

filename outbox email
   to='[email protected]'
   type='text/html'
   subject='subject line'
   attach=('~path1/creat_bssa.csv' '~path2/creat_bssa.csv');

data _null_;
file outbox;
put 'Hi';
run;

[Doug____]

Now the code runs but no email appears.

[SASKiwi]

Are you running this locally on your PC or on a remote SAS server? If it is on your PC then it is likely you need additional settings to get email working. If you are running this on a remote SAS server then talk to your SAS administrator about the correct settings for emailing from SAS.