Mail Merge

[Guest]

I have a database which I'm in the process of completing but i need help on
mail merge please.

I have added a command button to the form so that when users are viewing
individual records, they can click the button and produce a letter for that
particular record.

I have set up the command button with the following event:

Private Sub Completion_Letter_Click()
On Error GoTo Err_Completion_Letter_Click

Dim oApp As Object

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

Exit_Completion_Letter_Click:
Exit Sub

Err_Completion_Letter_Click:
MsgBox Err.Description
Resume Exit_Completion_Letter_Click

End Sub


All that seems to do is open Microsoft Word, so how do I add my file name in
and get the mail merge to work?

 

[pietlinden]

Albert Kallal wrote a module that does all this. Works a charm. If
you search "Super Easy Word Merge" in this NG, I think you'll find it.