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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

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