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"
.Visible = True
.Documents.Open (PathDocu & "MailerTemp.dotx")
Thanks in advance for the help.
0 · ·