mail merge from ms access to ms word vba

jgolba99

Hello everyone I am trying to create a program that when you click a button it sends a mail merge to word and replaces all the bookmarks that I have setup. I am using 2010 for both products. I have pretty much everything done, but I am not sure how to have it open a document using a template. This is being done with vba. Right now it just opens the template and I don't really want that happening because I don't want anyone to save over the template. Here is the code that I have. I have only included the front end the rest of the code is just replacing the bookmarks.

Private Sub cmdPrint_Click()
Dim MyWord As Word.Application
Dim PathDocu As String


If Me.LawFirmName <> "" Then
Set MyWord = New Word.Application
PathDocu = "C:Word Template"

With MyWord

.Visible = True
.Documents.Open (PathDocu & "MailerTemp.dotx")

Thanks in advance for the help.

jgolba99

I found the answer elsewhere and I figured I would post a response so that if anyone else had this issue they could find it here.

Private Sub cmdPrint_Click()
Dim MyWord As Word.Application
Dim PathDocu As String


If Me.LawFirmName <> "" Then
Set MyWord = New Word.Application
PathDocu = "C:Word Template"

With MyWord

.Visible = True
.Documents.Open (PathDocu & "MailerTemp.dotx")


This is the original post question and the answer is to change this portion .Visible = True
.Documents.Open (PathDocu & "MailerTemp.dotx")

If you change the .Open to .Add it will open a new document using the template.