I have a database that has various mail merge word templates that it uses.
My client has just upgraded from Office XP to Office 2003.
All the mail-merge templates now no longer populate with data.
If you open them in Word they create the link and prompt for the value that should be in the related form and run the query no problem.
When you access them from Access they don't have the data passed to them. No errors come up but they data fails to pass over.
The code I am using is as follows:-
Dim stDocName As String
If (ChildID.Value > 0) Then
stDocName = "QryLetterB"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenDynamic
rst.LockType = adLockOptimistic
rst.Open "select * from tblChild"
'Open word document
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
oApp.documents.Add "c:\Database\Templates\Letters\Blank.dot"
DoCmd.Close acForm, "FrmBlank"
DoCmd.Close acQuery, "QryLetterB"
Else
MsgBox "Please select a child"
End If
What has changed in 2003 and how do I go about fixing it?
Thanks
