mail merge from ms access to ms word vba

Fri, 16 Dec 2011 15:25:36 -0700

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.

Re: mail merge from ms access to ms word vba

Tue, 27 Dec 2011 12:59:17 -0700

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.

'mail merge from ms access to ms word vba' Thread RSS Feed

mail merge from ms access to ms word vba

Re: mail merge from ms access to ms word vba