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;
please see attachments for result and expected
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.