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-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

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