BookmarkSubscribeRSS Feed
P5C768
Obsidian | Level 7

   After upgrading to 9.4, ODS MSoffice2k now adds a text frame/box around text when using it to include text in the body of an outlook email.  Is there an option to do turn this off?  I have tried FRAME= and BORDER= but those don't appear to control that feature.  I've attached an example of what I'm seeing.  Thanks!


Capture.PNG
6 REPLIES 6
ballardw
Super User

ods tagsets.msoffice2k file='' options(doc='Help');

Should show the options available.

I don't see anything related to borders/cells etc. in the 9.3 version. Good luck.

Cynthia_sas
SAS Super FREQ

Hi:

ODS MSOFFICE2K is an HTML-type of destination. Why did you post the question in the SAS/GRAPH and ODS GRAPHICS forum. Are you creating and sending HTML files with SAS/GRAPH output or ODS GRAPHICS output in your Outlook mail? You indicated that MSOFFICE2K "includes text in the body of an outlook email" -- so I am confused. Is your text box the result of an ANNOTATE? Or the result of a TITLE statement? You did not indicate what style template or CSS file you used to create your output. You did not show your code, so it is hard to speculate and FRAME=/BORDER= might not be the right things to try, but it is only speculation, since you showed so little of your output and none of your code.
     

  The bottom line is that you might want to open a track with Tech Support if you can't show your more of your code and share some sample data to test with. When I run the attached code, I do NOT see a box or frame around the title. Without seeing your code or how you are creating your text, it is impossible to make a constructive suggestion.
    

Cynthia
     

ods msoffice2k file='c:\temp\text.html';

title 'Please see the attached dashboard for more information';

proc print data=sashelp.class;

run;

ods msoffice2k close;

P5C768
Obsidian | Level 7

I posted it here because it uses an ODS tagset, where should MSOFFICE2K questions posted?

Code posted below.  In this example, there are two boxes being added, each of them around the ods msoffice2k text output (interestingly, the PROC REPORT code does not generate a box around the input)

option emailhost='localhost';

filename mymail email

  from = "me@me.com"

  to  =  "me@me.com"

  sender="me@me.com"

  subject="Dashboard - Week Ending &end."

  attach = ("Dashboard - Week Ending &end..pdf")

  content_type="text/html";

ods MSOffice2K

body=mymail style=analysis;

ods escapechar="^";

ods msoffice2k text="Please see the attached dashboard for the week ending &end.. ^2n";

<PROC REPORT code here>

ods msoffice2k text="^2nPlease let me know if you have any questions.";

ods msoffice2k close;

Cynthia_sas
SAS Super FREQ

Hi:

If you are NOT using any SAS/GRAPH or ODS GRAPHICS code in your program, then the correct Forum would be the ODS and Base Reporting Forum 

  When I run some test code in SAS 9.4, I do not observe the border around the text box. This is probably a question for Tech Support. Or the border could have been added by the mail program rendering the HTML tags. What happens if you make the HTML file separately and send it as an attachment instead of in the body of the email???

cynthia

%let end = 12/26/2014;

 

ods MSOffice2K body='c:\temp\testtext.html' style=analysis;

ods escapechar="^";

ods msoffice2k text="Please see the attached dashboard for the week ending &end.. ^2n";

     

proc report data=sashelp.class nowd;

title "my version of SAS &sysvlong";

run;

      

ods msoffice2k text="^2nPlease let me know if you have any questions.";

      

ods msoffice2k close;


no_border.png
P5C768
Obsidian | Level 7

Even without attaching a file, just using the text line, a border is created.  I noticed that a outline/box is standard for the analysis style, so I have been trying to create a custom style using proc template to remove all borders around a text box, but it still adds the borders in the email body.  I have reached out to tech support, thank you for your time.

hagen_glatzel
Calcite | Level 5

How did you solve this issue?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 6 replies
  • 2771 views
  • 0 likes
  • 4 in conversation