mail merge from ms access to ms word vba - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

mail merge from ms access to ms word vba

jgolba99jgolba99 Posts: 9Member
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.

Comments

  • jgolba99jgolba99 Posts: 9Member
    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.
Sign In or Register to comment.