BookmarkSubscribeRSS Feed
radha009
Quartz | Level 8

on my email generate the font size changes to big font and grid lines are disappear on attaching the files to the email.

 

my code:

 

PROC TEMPLATE;
DEFINE STYLE STYLES.TEST;
PARENT=STYLES.Normal;
CLASS BODY /
HTMLSTYLE="BORDER:NONE";
CLASS SYSTITLEANDFOOTERCONTAINER /
HTMLSTYLE="BORDER:NONE";
CLASS PAGE /
HTMLSTYLE="BORDER:NONE";
END;
RUN;

filename mailbox email
subject="on-call schedule"
from='test@mail.com'
to=('test@mail.com')
attach= ("&outfile" "&outfile1")
type="text/html";

ods MSOffice2K body=mailbox style=STYLES.TEST;
/***********************************Report***********************************/
proc odstext;
p "Good Afternoon, Application Management! ";
run;
title 'OnCall Support this weekend : ' &x. '-' &a.;
OPTIONS NOCENTER;
proc report data=call.week_sch
STYLE(Header)={background=lightgray foreground=black}
style(column)={background=White foreground=black}
style(report)={width=14in} split='^';
column Support_Type Friday_oncall Saturday_oncall Sunday_oncall Monday_oncall;
define Support_Type / display style(header)=[font_face='Arial' font_size=11pt] style(column)=[just=left fontsize=11pt]'L2 Support Schedule';
define Friday_oncall / display style(header)=[font_face='Arial' font_size=11pt] style(column)=[just=left fontsize=11pt] "Friday (&x)";
define Saturday_oncall / display style(header)=[font_face='Arial' font_size=11pt] style(column)=[just=left fontsize=11pt] "Saturday (&y)";
define Sunday_oncall / display style(header)=[font_face='Arial' font_size=11pt] style(column)=[just=left fontsize=11pt] "Sunday (&z)";
define Monday_oncall / display style(header)=[font_face='Arial' font_size=11pt] style(column)=[just=left fontsize=11pt] "Monday (&a)";
run;

footnote "***Please see the attachment for oncall Contacts & Weekend Change requests ";

ods msoffice2k close;

 

 

 

 

 

1 REPLY 1
radha009
Quartz | Level 8

please see attachments for result and expected

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 533 views
  • 0 likes
  • 1 in conversation