Merge word with a query

S

SHIPP

I have the following code in Access 97:

Dim objWord As Word.Application

Set objWord = GetObject("\\plbtpr02\data\CorpSourcing\Shared\
AgreementFront\signature.doc", "Word.Document")
objWord.Application.Visible = True
objWord.MailMerge.Execute

The document has been set up to utilize a query in the database I am
currently in as its' source. When I try to compile I get an error at:

objWord.MailMerge.Execute

The error is:

Method or data member not found.

In my references I have the following checked off in the following order:

Visual Basic For Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library
Microsoft Word 8.0 Object Library
Microsoft Excel 8.0 Object Library
Microsoft Office 8.0 Object Library
Microsoft Visual Basic for Applications Ext...

The message indicates its' a reference but they all look good to me. Any
ideas? I got this bit of code from Microsoft Q159328. Any help would be
greatly appreciated.
 

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

Working outlook via vba code with xlsx - error 0
Problems starting Word from Excel VBA 3
Run Time Error = 432 6
Reference Issues 3
Mail Merge - DB Admin Locked Error 0
GetObject Error 13 Type mismatch 9
Merge Word 1
2nd instance of database pops up 0

Top