I have done some searching on this site and know exactly where my problem lies, but am having troubles in applying a fix for it.
My Access database uses VB to merge to a word document all quite nicely under Word 2000 but falls flat with Word XP. It seems that this problem is caused by the differences between the msword9 and 10 libraries.
I have found my way through to site http://support.microsoft.com/default.aspx?scid=kb;EN-US;279462
which shows that you must add a line "SubType:= wdMergeSubTypeWord2000" but when I do this, I get a message a VB compile error (variable not defined) on my pc that only has Word2000. I suppose that the simple solution is just to upgrade to XP but I do not want to do this in case I cascade a whole host of other problems.
The code that I have is
Function MergePGRschWebApp(theApp As Long)
Dim oApp As Object
Set oApp = CreateObject("Word.Applica
oApp.Visible = True
' Make Word visible.
oApp.application.Visible = True
' Set the mail merge data source
Name:="access database", _
BQ=access database;FIL=RedISAM", _
SQLStatement:="Select * from Q_WEB_PGRsch_Applications where id = " & theApp, _
' ' Execute the mail merge.
' oApp.Application.Quit (0) 'wdDoNotSaveChanges
' Set oApp = Nothing ' Dispose of word object
Any help is greatly appreciated