Word Automation; template showing up

A

AJ

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 to different word documents
opening up. Is there a way to avoid this. I am just wanting the user to see
the merged document in the print preview format. 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge from Access, template showing up also 2
Access 2003 Mail Merge to Word 2003 using query to locate the specific record being displayed 8
Email Mail Merge from Access 2003 3
Q: simple Access to Word mail merge 8
User defined type not defined error in mail merge from Access 2003 1
Mail Merge Processing Problem 0
mailmerge from access 2007 to word 2007 5
Mail Merge - DB Admin Locked Error 0

Top