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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1667 views
  • 0 likes
  • 2 in conversation