Thanks Welshgasman - issue resolved.
Now I have another issue. I am unable to reference the shapes in Access VBA. I get an error message "Method or data member not found":
Code:
For Each shp In .ActiveDocument.Shapes If .ActiveDocument.Trim(Left(shp.TextFrame.TextRange.Text, 17)) = "Student Name here" Then
shp.TextFrame.TextRange.Text = Rst1!FirstName & " " & Rst1!Surname
End If
Next
The debug window shows the member not found, is ".TextRange.Text....".
Running the above code in the WORD document, it runs 100%, but as soon as I run it in VBA, I get the error message.
Any idea why?
Thanks