ODS EMAIL only HTML code appears in the body no table

xxxxxxxxx — Thu, 28 Aug 2014 14:35:53 GMT

Hi guys. I have a problem somewhere that I am unable to pinpoint. I run ODS EMAIL with a simple statement that produces e-mail output on everyone elses machine except mine. They get a table in the e-mail body while I only get HTML code. See bellow.

Sample code Example:

outbox email to='removedemail@aol.com' type='text/html'

subject='Temperature conversions';

temperatures;

do centigrade = -40 to 100 by 10;

9/5+32;

output;

end;

;

html3 body=outbox /* Mail it! */ rs=none; /* <<< THATs it

'Centigrade to Fahrenheit conversion table';

print;

id centigrade
var fahrenheit;

;

html close;

Their output in the body of the e-mail:

-40	-40
-30	-22
-20	-4
-10	14
0	32
10	50
20	68
30	86
40	104
50	122
60	140
70	158
80	176
90	194
100	212

My output in the body of the e-mail:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2
Final//EN">

<HTML>

<HEAD>

<TITLE>SAS Output</TITLE>

<!--

// This script is to load all object onLoad() functions
function startup(){ } function shutdown(){ } //--> </SCRIPT>

<!--

var _info = navigator.userAgent

var _ie = (_info.indexOf("MSIE") > 0

&&
_info.indexOf("Win") > 0

&&
_info.indexOf("Windows 3.1") < 0) var _ie64 =
_info.indexOf("x64") > 0 //--> </SCRIPT>

<TABLE
cellspacing=1 cellpadding=1 rules=NONE frame=VOID border=0 width=100%
bgcolor="#E0E0E0"> <TR>
<TD ALIGN=CENTER bgcolor="#E0E0E0">Centigrade to
Fahrenheit conversion table</TD>
</TR> </TABLE> </CENTER> 
<CENTER> <TABLE
cellspacing=1 cellpadding=7 rules=GROUPS frame=BOX border=1
bgcolor="#F0F0F0" bordercolor="#000000"> <thead>
<TR> <TD ALIGN=RIGHT
bgcolor="#B0B0B0">centigrade</TD>

<TD ALIGN=RIGHT
bgcolor="#B0B0B0">fahrenheit</TD>

</TR>

</thead>

<tbody>

<TR>

<!--

// This script is to load all object onLoad() functions
function startup(){

}

function shutdown(){

}

//-->

</SCRIPT>

</BODY>

</HTML>

Re: ODS EMAIL only HTML code appears in the body no table

Chevell_sas — Thu, 28 Aug 2014 14:43:06 GMT

You will need to have the -EMAILSYS option set to SMTP and the -EMAILHOST set to the value of your email server set before this would work correctly. These options have to be set on the config file or at startup.

Re: ODS EMAIL only HTML code appears in the body no table

esjackso — Thu, 28 Aug 2014 14:46:07 GMT

Just to be clear your email is set to view HTML email by default. If the same code generates emails to others that work, the real problem may be your email client.

Re: ODS EMAIL only HTML code appears in the body no table

xxxxxxxxx — Thu, 28 Aug 2014 14:50:32 GMT

How would I go about doing it on startup? This is the EG 6.1 version and I cant get to the configuration file. Thank you for the quick reply.

Re: ODS EMAIL only HTML code appears in the body no table

esjackso — Thu, 28 Aug 2014 14:54:13 GMT

I would guess your email settings are already setup if you are able to send email at all through SAS.

Re: ODS EMAIL only HTML code appears in the body no table

xxxxxxxxx — Thu, 28 Aug 2014 15:00:18 GMT

Yes the everything runs including sending the e-mail automaticaly, the problem is that the e-mail body contains that HTML code instead of actual table. I tried with others runing the exact same code it comes out just fine. I spent days trying to find a solution.

Re: ODS EMAIL only HTML code appears in the body no table

Chevell_sas — Thu, 28 Aug 2014 15:13:50 GMT

If everyone else can run this without a problem, what you will want to do is verify the values of these two options using the below PROC OPTIONS statement first.

proc options group=email;

run;

Re: ODS EMAIL only HTML code appears in the body no table

GeoffDer — Thu, 28 Aug 2014 15:33:40 GMT

At the risk of stating the obvious, the table is there in your email. But it's in HTML format.

So I agree with esjackso1 it's likely to be that your email client is not interpreting the HTML.

-40	-40
-30	-22
-20	-4
-10	14
0	32
10	50
20	68
30	86
40	104
50	122
60	140
70	158
80	176
90	194
100	212

-40	-40
-30	-22
-20	-4
-10	14
0	32
10	50
20	68
30	86
40	104
50	122
60	140
70	158
80	176
90	194
100	212

topic Re: ODS EMAIL only HTML code appears in the body no table in ODS and Base Reporting

ODS EMAIL only HTML code appears in the body no table

Re: ODS EMAIL only HTML code appears in the body no table

Re: ODS EMAIL only HTML code appears in the body no table

Re: ODS EMAIL only HTML code appears in the body no table

Re: ODS EMAIL only HTML code appears in the body no table

Re: ODS EMAIL only HTML code appears in the body no table

Re: ODS EMAIL only HTML code appears in the body no table

Re: ODS EMAIL only HTML code appears in the body no table

-40	-40
-30	-22
-20	-4
-10	14
0	32
10	50
20	68
30	86
40	104
50	122
60	140
70	158
80	176
90	194
100	212