Use a Template to format Word doc generated from Access VBA button click

[LindaRuble]

Hello,



I have already accomplished creating a word document by clicking on a button.
Here is the code:

Private Sub CreateWord_Click()
On Error GoTo cmdOK_Error
Dim stDocName As String
stDocName = "Client-Status-Linda"
DoCmd.OutputTo acOutputQuery, stDocName, acFormatRTF, "Word.rtf", True
cmdOK_Error:
Resume Next
End Sub

Also, I have attached the generated documented.

It generates a standard word document, however, I would like to be able to choose colors, font style, etc.


I know that you can use a template with the OutputTo method, however, I have not been successful in making it work.


expression.OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding)


Please let me know how to accomplish generating a word file and formatting it with a template. Any help would be appreciated.



Thanks


Linda

[Rod]

Sorry, I don't think the template helps you. Here's the official MS help; it seems restricted to three types only.

TemplateFile

Optional

Variant

A string expression that's the full name, including the path, of the file you want to use as a template for an HTML , HTX , or ASP file.