topic Re: ODS MSOffice2k after 9.4 Upgrade in Graphics Programming

ODS MSOffice2k after 9.4 Upgrade

P5C768 — Thu, 18 Dec 2014 21:42:53 GMT

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!

Re: ODS MSOffice2k after 9.4 Upgrade

ballardw — Thu, 18 Dec 2014 22:29:25 GMT

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.

Re: ODS MSOffice2k after 9.4 Upgrade

Cynthia_sas — Fri, 19 Dec 2014 01:56:11 GMT

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;

Re: ODS MSOffice2k after 9.4 Upgrade

P5C768 — Fri, 19 Dec 2014 16:10:13 GMT

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";

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

ods msoffice2k close;

Re: ODS MSOffice2k after 9.4 Upgrade

Cynthia_sas — Sat, 27 Dec 2014 17:08:32 GMT

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;

Re: ODS MSOffice2k after 9.4 Upgrade

P5C768 — Sun, 11 Jan 2015 15:56:42 GMT

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.

Re: ODS MSOffice2k after 9.4 Upgrade

hagen_glatzel — Tue, 28 Apr 2020 09:33:30 GMT

How did you solve this issue?