View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AJ AJ is offline
external usenet poster
 
Posts: 36
Default Mail Merge from Access, template showing up also

I have a document set up as a template for mail merge using data from a table
in access. Everything is working, except when the document opens up for the
user to view, so does the template, so you have 2 different word documents
opening up. Is there a way to avoid this. I am just wanting the user to see
the merged document, not the template. I have included my code
below. I appreciate any time and advise on this...

Dim objWord As Word.Document
Set objWord = GetObject("G:\Users\AJ\Testing.doc", "Word.Document")

objWord.MailMerge.OpenDataSource _
Name:="G:\Users\AJ\welders\weldxp.mdb", _
LinkToSource:=True, _
Connection:="TABLE tblTestLabFacility", _
SQLStatement:="SELECT * FROM [tblTestLabFacility]"
' Execute the mail merge.
objWord.MailMerge.Execute
' Make Word visible.
objWord.Application.Visible = True

Thank You