BookmarkSubscribeRSS Feed
arpitagarwal512
Calcite | Level 5

Hi All,

 

I want to send mail which have HTML body figures and at the same time it want to send this summary as a excel attachment. As far as i did the research i am only able to do this task in either ways that means at a time i can send attachment or send body  figures in email.My requirement is to do both task in one shot

1 REPLY 1
ChrisHemedinger
Community Manager

In The Many Faces of HTML@Chevell_sas covers some e-mail techniques for SAS output and included images.  I've included his example code, but read the post for all of the explanation.

 

  filename mymail email to="myemail@company.com"
                       subject="Forecast Report"
                       attach=('C:\SAS.png' inlined="logo")
                       content_type="text/html";   
 
   ods msoffice2k file=mymail rs=none style=htmlblue options(pagebreak="no");
     title j=l '<img src="cid:logo" width="120" height="100" />';
     title2 "Report for Company XYZ";
 
 
   proc odstext;
      H3 "Confidential!";
   run;
 
   title;   
   proc print data=sashelp.prdsale;
   run;
 
   ods msoffice2k close;
SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1659 views
  • 0 likes
  • 2 in conversation