***Resolved*** Mailmerge Problems Again -

I am trying to do a Word mailmerge from VB taking the Receipt data from an Access 97 Table. The code that I am trying to use opens my mailmerge document allowing me to view it in Word before printing it. Although I'm sure the code has errors in it and has lots of room for improvement, it does work.

However, upon closing Word and returning to my application it crashes if I try to do another mailmerge without closing my application. Tells me that VB has caused a fault in Kernal32.dll.

Usually can't get rid of the error and have to reboot. As long as I don't try to do another mailmerge before closing the application everything else works ok so it has to do with this code. I have included the code I'm using below.

Private Sub cmdPrintReceipts_Click()

Dim Filename1 As String
Dim oMyWordApp As Object
Dim oWordDoc As Object

Set oMyWordApp = CreateObject("Word.application")
oMyWordApp.Application.Visible = True
Filename1 = App.Path + "\Receipt_Letter.Doc"
oMyWordApp.Documents.Open Filename1

Set oWordDoc = oMyWordApp.ActiveDocument
oWordDoc.MainDocumentType = wdFormLetters

oWordDoc.MailMerge.OpenDataSource _
Name:=App.Path + "\GCDistribution.mdb", _
LinkToSource:=True, _
AddToRecentFiles:=False, _
Connection:="TABLE Receipts", _
SQLStatement:="Select * from [Receipts]"

oWordDoc.MailMerge.Destination = wdSendToNewDocument
oWordDoc.MailMerge.Execute

'Close the original document and make Word visible so that
'the mail merge results are displayed
oWordDoc.Close False
oMyWordApp.Visible = True

'Prevent save to Normal template when user exits Word
oMyWordApp.NormalTemplate.Saved = False

Set oMyWordApp = Nothing
Set oWordDoc = Nothing

Exit Sub

End Sub

Any help here would be appreciated,

I also have a couple of related questions. 1) When I preview this as it is doing now, how can I make it display iautomatically n Print Layout View instead of Normal View.

2) If I should later decide that I don't need to preview the merged documents before printing, what would I need to change to get it to open Word minimized and automatically print the merged documents and then close Word?

Thanks for your input.

Rev. Michael L. Burns