Adding Email Templates to the Standard Templates Folder

gmayor · #2 07-19-2023, 11:07 PM

What you have been told may simply mean that by default the Office templates folder is a hidden user folder. It can be accessed by entering (on the user's PC)
%appdata%\Microsoft\Templates
in the Windows File Explorer Address bar and pressing Enter.

Or from VBA

Code:

Dim sPath As String
sPath = Environ("APPDATA") & "\Microsoft\Templates\"

Thus you can copy a template from its current location to the required location on a given user's PC using a macro e.g.

Code:

Sub CopyTemplate()
Const sTemplatePath As String = "C:\Path\" 'The location of the template to be copied
Const sTemplateName As String = "TemplateName.oft" 'The filename of the template
Dim oFSO As Object
Dim sPath As String
    sPath = Environ("APPDATA") & "\Microsoft\Templates\"
    Set oFSO = CreateObject("Scripting.FileSystemObject")
    oFSO.CopyFile sTemplatePath & sTemplateName, sPath & sTemplateName, True
End Sub

It would be possible to change the templates folder to a different location, but given your comments, that might prove even more problematic for you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding in names across 8 document templates	Joxner	Mail Merge	1	06-27-2020 09:02 PM
Using Styles in Templates to help format text - Importing and working with Templates	daithy	Word	2	01-03-2020 05:06 PM
How To Move Saved New Templates From My Documents To My Templates?	woodbine	Word	9	04-02-2015 10:28 AM
Office 2010 change location workgroup templates appear in from My Templates folder	nickc	Word	0	11-20-2013 03:38 AM
Adding company templates into Powerpoint	dennisv	PowerPoint	0	04-09-2012 11:39 PM