MS ACCESS MERGE

[Rose]

I created a letter in MS word with insert field formula (to merge). On MS
access form design view I added a command button to open MS word application
on click. When I click the MS Word command button it open the letter I
created on the MS word but the data doesn’t merge. This is my code

Private Sub Command63_Click()
On Error GoTo Err_Command63_Click

Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True

Exit_Command63_Click:
Exit Sub

Err_Command63_Click:
MsgBox Err.Description
Resume Exit_Command63_Click

End Sub

 

[Albert D.Kallal]

If you are willing to spend just a few minutes reading, then perhaps you
might give my word merge a try.

If you follow the instructions. You can then setup form and merge the ONE
record to a word template with ONE line of code.

Note that in your example code, you have nothing that says to word to only
merge the ONE record.

Anyway, give my sample "super easy" merge a try, you can find it here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Do read the instructions on the web site on how to use/ and install. I have
step by step..and you should find it less work then what you have now....

Good luck...