2nd instance of database pops up

S

SHIPP

I have the following code in Access 97 which runs fine:


Dim objWord As Word.Document

Set objWord = GetObject("\\plbtpr02\data\Corp Sourcing\Shared\
AgreementFront\signature.doc", "Word.Document")
objWord.Application.Visible = True ' delete afterwards
objWord.MailMerge.Destination = wdSendToNewDocument
objWord.MailMerge.Execute
objWord.Application.Options.PrintBackground = False
objWord.Application.ActiveDocument.PrintOut
objWord.Application.ActiveDocument.Close False
objWord.Application.Quit

It merges the data with Word just as I want. The only problem is that it
pops up a 2nd instance of the database which the person has to subsequently
close. Does anybody know why or how I can close it through VB?
 

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

Merge Word 1
How to Control Which Printer MS Word Prints To 1
mailmerge in VBA using ACCESS 2000 0
Select print Tray 1
Selecting Printer Tray for Mail Merge 1
mailmerge with VBA using ACCESS 2000 1
Word merging 0
User defined type not defined error in mail merge from Access 2003 1

Top