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: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 488 views
  • 0 likes
  • 1 in conversation