View Single Post
  #1   Report Post  
 
Posts: n/a
Default mailmerge in Word 2002 fails

I've got a VB 6 application that runs mailmerge in word 2000.

I've been trying to upgrade the application to work with word 2002 with
no success. The client wants this yesterday. I've been all over the MS
website and have not come up with a solutin.

The request for the merge is:

With oDobj.ActiveWindow.Document
.MailMerge.OpenDataSource Name:=stConn, SQLStatement:=strSQL,
SubType:=wdMergeSubTypeWord2000
.MailMerge.Execute
.Close False
End With

What I've been playing with is the content of the stConn variable.
According to MS (289830) using a PATH string for the name and the
subtype reference above it should work just fine. It doesn't. I get the
template document open. When the OpenDataSource action fires nothing
happnes.

Any thoughts/comments? TIA