While the SubType attribute does appear when entering the .OpenDataSource
into the VBE, it is not documented in the Help file so I don't know what it
does. I would suggest that you try deleting it.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
wrote in message
oups.com...
The code that fails is:

With oDobj.ActiveWindow.Document
.MailMerge.OpenDataSource Name:=stConn, SQLStatement:=strSQL,
SubType:=wdMergeSubTypeWord2000
.MailMerge.Execute
(etc.)

The development machine is running XP pro. The test machine is running
Win 2000.

The connect := is not used. I tested with and without the connect with
no affect on the process.


Doug Robbins wrote:
That's still nowhere near enough to go on save that if it works on
one
machine and not another, it must be something peculiar about that
machine
that is causing the problem.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on
a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
wrote in message
oups.com...
ADDENDUM

There is no blank WORD dialog. The template document opens and the
fill
activity fails to take place. I did a test using msg to check the
variables and there was no change between my machine and the
client.

wrote:
I have an application that uses Mailmerge into Word 2002 from an
Access
database. At this point I'm extremely frustrated as this is a late
delivery on a commercial application.

The problem is that it runs on two machines that I have that have
Word
2002, but refuses to behave on the client machine.

The behavior on my machine is that the template document opens and
then
is replaced with the filled document. On the client machine the
template document opens, but then an empty Word dialog (no
document)
pops up. It seems that the replacement starts to activate, and
then
fails for no apparent reason.

Any comments would be extremely helpful.