Send email with text in the body section from sas

radha009 · Posted 03-27-2018 02:03 PM

How to from sas i can send email the generated report to recipient with report content in the body section.

radha009 · Posted 03-27-2018 03:42 PM

i got it to send the text in the body section. But email is sending fine. but the text looks as below

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta name="Generator" content="SAS Software Version 9.4, see www.sas.com"> <meta http-equiv="Content-type" content="text/html; charset=windows-1252"> <title>SAS Output</title> <style type="text/css">

<!--

.aftercaption

{

background-color: #E0E0E0;

border-spacing: 0px;

color: #000000;

font-family: Arial, Helvetica, sans-serif;

font-size: medium;

font-style: normal;

font-weight: bold;

padding-top: 4pt;

}

.batch

SuryaKiran · Posted 03-27-2018 03:46 PM

try CT in Filename

CT= "text/html"

Thanks,
Suryakiran

DaveHorne · Posted 12-20-2018 06:58 PM

Try the ODS MSOffice2K destination and see if that gives you better results:

filename mailbox email subject="Test Class Inventory"
       from="Info@YourDomain.com"
     sender="Info@YourDomain.com"
         to=("Dave@YourDomain.com")
       type="text/html";

ods listing close;
ods MSOffice2K body=mailbox style=HTMLblue;

TITLE1 "Test Class Inventory";
FOOTNOTE1 "Generated by the SAS System on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))";
proc print data=sashelp.class;
run;

ods _all_ close;
ods listing;

SuryaKiran · Posted 03-27-2018 03:44 PM

Check this code that I use to send a report with text in the email. Report will be in the body. I'm using a custom style since to make my email look good.

Proc template;
Define style Style.Custom;
parent=styles.Default;
style html
   "Common HTML text used in the default style" /
   'expandAll' = "<SPAN onClick=""if(msie4==1)expandAll()"">"
   'posthtml flyover line' = "</SPAN><HR size=3>"
   'prehtml flyover line' = "<SPAN><HR size=3>"
   'prehtml flyover bullet' = %nrstr("<SPAN><b>·</b>")
   'posthtml flyover' = "</SPAN>"
   'prehtml flyover' = "<SPAN>"
   'break' = "<br>"
   'Line' = "<HR size=3>"
   'PageBreakLine' ="";
end;
run;
FILENAME output EMAIL
	SUBJECT= "Test email"
	FROM="abc@abc.com" 
	TO=("123@abc.com")
 	CT= "text/html" /* Required for HTML output */ ;

ODS HTML File=output rs=none STYLE=Style.Custom ;

proc odstext;
   p "Hi, ";
   p "  ";
   p "  ";
   p "Add your text here";
   p "  ";
run;

proc print data=sashelp.class;
run;
proc odstext;
   p "  ";
   p "  ";
   p "  ";
   p "Thanks, ";
   p " Kiran  ";
   p "  ";
run;
ODS _ALL_ CLOSE;
Filename output clear;

Thanks,
Suryakiran

radha009 · Posted 12-20-2018 03:55 PM

i used same proc template and tried stil getting the same <DocType...> format

Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Re: Send email with text in the body section from sas

Click image to register for webinar

Classroom Training Available!