healthfoundation
asked on
How to standardise the fonts in office 2007 via group policy
Hi,
I would like to standardise all the users fonts in Office 2007 to Arial, 11. I cannot seem to find a way to do this with the Office 2007 ADM files. Is it possible and how can i do it?
I would like mainly outlook and word to be standardised but if excel could aswell that would be great.
Also i would like to lock the signatures so that users cannot edit these once they have been set by me manually on the user pc.
I would like to standardise all the users fonts in Office 2007 to Arial, 11. I cannot seem to find a way to do this with the Office 2007 ADM files. Is it possible and how can i do it?
I would like mainly outlook and word to be standardised but if excel could aswell that would be great.
Also i would like to lock the signatures so that users cannot edit these once they have been set by me manually on the user pc.
ASKER
Thanks enzogoy, could you post the script you use for me please?
Thanks!
Thanks!
Here is how to create your template. You have to create this two files first (Normal.dotm and NormalEmail.dotm), put them on the network location and then put the command into your login script (I assume you used batch file).
http://blogs.msdn.com/templates/archive/2008/04/08/creating-and-sharing-word-2007-templates.aspx
Put the following line in your batch file.
Use this if your users are using Microsoft templates at the moment and you want your new template to overwrite it.
copy "\\Network location\folder\Normal.dot m" "%userprofile%\Application Data\Microsoft\Templates\"
If your users already have their own template and you don't want to overwrite it then:
xcopy "\\Network location\folder\Normal.dot m" "%userprofile%\Application Data\Microsoft\Templates\" /d
*** the xcopy command will check if the file exist then it will do nothing, else it will copy the file over.
For outlook, you only change the file name in the script to NormalEmail.dotm.
If you have a folder which only have these two template file then you can replace the file name in command with *.* .
for example:
copy "\\Network location\folder\*.*" "%userprofile%\Application Data\Microsoft\Templates\"
http://blogs.msdn.com/templates/archive/2008/04/08/creating-and-sharing-word-2007-templates.aspx
Put the following line in your batch file.
Use this if your users are using Microsoft templates at the moment and you want your new template to overwrite it.
copy "\\Network location\folder\Normal.dot
If your users already have their own template and you don't want to overwrite it then:
xcopy "\\Network location\folder\Normal.dot
*** the xcopy command will check if the file exist then it will do nothing, else it will copy the file over.
For outlook, you only change the file name in the script to NormalEmail.dotm.
If you have a folder which only have these two template file then you can replace the file name in command with *.* .
for example:
copy "\\Network location\folder\*.*" "%userprofile%\Application
ASKER
Hi, thanks for this.
We use VB script but i think i can knock something up to do this.
We use VB script but i think i can knock something up to do this.
Please let me know if you in trouble with VB script.
enz
enz
ASKER
I'm currently setting up one bit at a time in a test script
This is what I currently have in the login script.
************************** ********** ********** ********** *******
'Copy Word 2007 Normal Template to the Local Hard Disk
Dim FSO
Set FSO = CreateObject("Scripting.Fi leSystemOb ject")
FSO.CopyFile "\\"SERVERNAME"\NETLOGON\N ormal.dotm ", "C:\Documents and Settings\"USERNAME"\Applic ation Data\Microsoft\Templates\"
************************** ********** ********** ********** *******
With server name and user name replaced with the right words. Now that script above works but obviously this is no good for serperate users as "USERNAME" is not a vaiable. i have tried using "%userprofile%\Application Data\Microsoft\Templates\" but i get a 800A004C error on the VBscript saying cannot find path.
Can you help?
This is what I currently have in the login script.
**************************
'Copy Word 2007 Normal Template to the Local Hard Disk
Dim FSO
Set FSO = CreateObject("Scripting.Fi
FSO.CopyFile "\\"SERVERNAME"\NETLOGON\N
**************************
With server name and user name replaced with the right words. Now that script above works but obviously this is no good for serperate users as "USERNAME" is not a vaiable. i have tried using "%userprofile%\Application
Can you help?
ASKER
Can anyone help with my post above???
Could you please try this one:
************************** **
'Copy Word 2007 Normal Template to the Local Hard Disk
Dim FSO, strDirectory, strUserProfile, objFolder
Set FSO = CreateObject("Scripting.Fi leSystemOb ject")
Set oShell = CreateObject( "WScript.Shell" )
strUserProfile = oshell.ExpandEnvironmentSt rings("%us erprofile% ")
strDirectory = strUserProfile & "\Application Data\Microsoft\Templates\"
If FSO.FolderExists(strDirect ory) Then
FSO.CopyFile "\\SERVERNAME\NETLOGON\Nor mal.dotm", strUserProfile & "\Application Data\Microsoft\Templates\"
Else
Set objFolder = FSO.createFolder(strDirect ory)
FSO.CopyFile "\\SERVERNAME\NETLOGON\Nor mal.dotm", strUserProfile & "\Application Data\Microsoft\Templates\"
End if
************************** *********
Replace your SERVERNAME to the real server name, everything else keep the same.
enz
**************************
'Copy Word 2007 Normal Template to the Local Hard Disk
Dim FSO, strDirectory, strUserProfile, objFolder
Set FSO = CreateObject("Scripting.Fi
Set oShell = CreateObject( "WScript.Shell" )
strUserProfile = oshell.ExpandEnvironmentSt
strDirectory = strUserProfile & "\Application Data\Microsoft\Templates\"
If FSO.FolderExists(strDirect
FSO.CopyFile "\\SERVERNAME\NETLOGON\Nor
Else
Set objFolder = FSO.createFolder(strDirect
FSO.CopyFile "\\SERVERNAME\NETLOGON\Nor
End if
**************************
Replace your SERVERNAME to the real server name, everything else keep the same.
enz
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I scratch my head to find a better solution but no luck.
enz