Incode Systems Logo Incode Systems, Inc.
www.incodesystems.com
Please E-mail: webmaster [at] incodesystems.com if you have information to contribute.
(Last modified: Monday, September 4, 2017 2:31 pm)

Microsoft Office

Office 2010: Broken links in text emails
Office 2010: Paper size, Orientation not saved in the document
OLE Automation fails when run from Task Scheduler


(top)

Office 2010: Broken links in text emails

Symptoms:
You send text emails with lines longer than the automatic text wrap setting (default 76) and web links are broken. Recipients are unable to click the links in your email.

Solution:
You could increase the setting to the maximum of 132: File / Options / Mail / Message format / Automatically wrap text at character
A better way is to change the encoding for outgoing messages from the default Western European (ISO) to Unicode (UTF-8):
File / Options / Advanced / International options / Preferred encoding for outgoing messages


(top)

Office 2010: Paper size, Orientation not saved in the document

Symptoms:
You have a document with a paper size that is not the default paper size for the printer. Every time you print the document you have the specify the paper size and / or orientation. Even though you check the box in Publisher "Save settings with publication", the settings have to be specified each time you print.

Solution:
Office 2010, unlike previous versions, requires that the page size and orientation of the document itself match the paper size and orientation of the printer for the settings to be saved in the document. In Publisher, set Page Design / Size to a matching size in the File / Print / Settings, and set Page Design / Orientation to match File / Print / Printer Properties / Orientation.


(top)

OLE Automation fails when run from Task Scheduler

Symptoms:
A program or script that uses OLE automation to open an MS Office document, runs fine when run by a user, but the same routine fails on creating an "Excel.Application" OLE object when run from the task scheduler.

Solution:
Change the Task Scheduler from "Run whether user is logged on or not" to "Run only when user is logged on".

If this does not solve the problem, or it is important for the process to run when the user is logged on or not, do this:

Open an elevated command prompt by right-clicking the shortcut and select "Run as administrator"

If Windows x64 (64-bit), run this command:
MD C:\Windows\SysWOW64\config\systemprofile\Desktop

If Windows x86 (32-bit), run this command:
MD C:\Windows\System32\config\systemprofile\Desktop