topic Re: How to Email Excel file with Multiple work sheets as attachment using SAS EMAIL ? in SAS Programming

How to Email Excel file with Multiple work sheets as attachment using SAS EMAIL ?

sdixit — Wed, 10 Aug 2016 20:25:37 GMT

Hi ,

How to Email Excel file with Multiple work sheets as attachment using SAS EMAIL ?

I have a xlsx file to attach in my email

Filename hmmail_1 email TO=&Email_to_Id. CC=&Email_cc_Id.

Subject="abcth.."

 

Attach="/xx/xx/xx/xx./xx..xlsx" ;

　

%Macro Send_Mthly_Email;

Data _null_;

file hmmail_1 lrecl=375;

put "Hi All," //;

put "The report is completed."/;

put "Attached report is available ." //;

put "Thanks," /;

put "&Thanks_Name.";

output;

run;

%Mend;

%Send_Mthly_Email;

Re: How to Email Excel file with Multiple work sheets as attachment using SAS EMAIL ?

DarthPathos — Thu, 11 Aug 2016 00:19:09 GMT

Hi -

I use this paper all the time for how to build a macro for emailing. You should be able to incorporate the code from the paper into your code and have everything work.

Good luck!

Chris

Re: How to Email Excel file with Multiple work sheets as attachment using SAS EMAIL ?

RW9 — Thu, 11 Aug 2016 08:25:44 GMT

Just two things. Firstly your companies email system will have size limitations on the emails you send - the reason being is that email is not a report delivery system, its principally for messaging. Secondly, depending on setup and data in the report, you could breach rules on sending data as email (at least outside the company network) is not secure. I would advise you, if your data has anything confidential, to address where and how you deliver reports - there are far better methods to get reports out to people, the use of secure portals - sharepoint for instance - or other secure platforms.

Re: How to Email Excel file with Multiple work sheets as attachment using SAS EMAIL ?

DarthPathos — Thu, 11 Aug 2016 11:09:52 GMT

Ooh good point @RW9! I'm totally embarassed I didn't think to mention that, considering I work in a hosptial where privacy is a huge deal 🙂

There are papers about encrypting data sets with WinZip and other utilities using SAS, but Sharepoint or internal share drive would be preferred.

Chris

Re: How to Email Excel file with Multiple work sheets as attachment using SAS EMAIL ?

sdixit — Thu, 11 Aug 2016 19:57:48 GMT

Hi Chris,

Thanks for sharing the paper. Indeed it was helpful for me. \