Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!

How i can change borders in table in email with html

Reply
Occasional Contributor
Posts: 14

How i can change borders in table in email with html

[ Edited ]

Hello!

I trying to customize my table, but can change border in email. I just need some border like first screenshot.

options emailsys=smtp;
options emailport=25;
options emailauthprotocol=none;

filename temp email /*финальная*/
          to=(ASD@somemail.com)
        type='text/html'
        subject='Отчет Предпочтения новых игроков на сайте'
        ;

options orientation=landscape; 
ods html body=temp  style=noline;
ods html text = "Good Morning,";

ods html text = "";

proc print data=work.report_first_game_2 label noobs style(report)={posttext="Рассматриваются не уникальные игроки." };
 title1 'Предпочтения новых игроков сайта';
format date nldate20.
		game_rl
		game_6_45 nlnum10.;
	label date="Дата" 
		game_12_24="12/24" 
		game_4_20="4х20" 
		game_5_36="5x36" 
		game_6_36="6x36" 
		game_6_45="6x45" 
		game_matchbol="МатчБол" 
		game_7_49="7x49" 
		game_bonus="БИ" 
		game_duel="Дуэль" 
		game_keno="Кено" 
		game_prikup="Прикуп" 
		game_rapido="Рапидо" 
		game_rl="РЛ" 
		game_top_3="Топ-3" 
		game_zl="ЖЛ" 
		game_zp="ЗП" 
		total="Всего";
var		date / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center background=#dbdbdb borderwidth=2pt bordercolor=black] style(head)=[borderwidth=3pt bordercolor=black height=40pt width=60pt TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center ];
var  	game_4_20
		game_5_36 
		game_6_45 
		game_matchbol
		game_7_49 /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center  ] style(head)=[ TEXTALIGN=CENTER background=#ffe4c4 VERTICALALIGN=center width=40pt];
var 	game_rl
		game_zl
		game_6_36 
		game_zp / style(head)=[width=40pt TEXTALIGN=CENTER background=#98c793 VERTICALALIGN=center] style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ];
var		game_duel
		game_keno 
		game_prikup / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center  ] style(head)=[ width=42pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center];
var		game_rapido / style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center  ] style(head)=[ width=44pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center];
var		game_top_3 
		game_12_24 /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ width=42pt TEXTALIGN=CENTER background=#afdafc VERTICALALIGN=center];
var		game_bonus /style(data)=[TEXTALIGN=CENTER VERTICALALIGN=center ] style(head)=[ TEXTALIGN=CENTER width=40pt background=#cda4de VERTICALALIGN=center];
var		total / style(data)=[TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center ] style(head)=[TEXTALIGN=CENTER background=#dbdbdb VERTICALALIGN=center];
footnote;
run;

ods _all_ close;


In SAS EG it looks like 

image.png

but in email it doesn't change:

image.png

 

 

SAS Super FREQ
Posts: 831

Re: How i can change borders in table in email with html

Posted in reply to DavidBesaev

Which Email program do you use to look at the email?

 

If it is outlook, change your destination to HTML3 or TAGSETS.MSOFFICE2K and see if it displays any better.

 

they both generate HTML output, but in a way that Outlook will display better.

Occasional Contributor
Posts: 14

Re: How i can change borders in table in email with html

Posted in reply to Bruno_SAS
Yeap, outlook.
I solved this problem by changing the style from noline to snow. It's looks like i can chage it by some parameter at style. But I didn't find. Smiley Sad
Ask a Question
Discussion stats
  • 2 replies
  • 167 views
  • 1 like
  • 2 in conversation