Please help! Strange behavior: Access > Word Mail Merge code

[Linda Cacina]

Hello all you fine folks,

Here is some code I am using to merge data from a single record Access
2K3 table into a NEW word document based on a pre-defined Word merge
template doc. All I want to happen is as follows:

User defines a storage path and name for the new Word document then
clicks a "Create" button on a form. From that point on I use the
following code:

=============== ======= BEGIN CODE =============== =============
Public Sub MergeIt(docPath As String)

Dim fID As Long
Dim strSQL As String
Dim objWord As Word.Document

On Error GoTo MergeIt_Error

If Me.Dirty Then DoCmd.RunComman d acCmdSaveRecord

fID = Me.txtFaxID

strSQL = "SELECT tblSavedFaxes.F axID, tblSavedFaxes.F rom,
tblSavedFaxes.F ullName, " & _
"tblSavedFaxes. Facsimile, tblSavedFaxes.T elephone, " & _
"tblSavedFaxes. CID, tblSavedFaxes.[DACSFileNum],
tblSavedFaxes.I mportance, " & _
"tblSavedFaxes. RE, tblSavedFaxes.M sgBody INTO
TEMP_FaxPrint " & _
"FROM tblSavedFaxes WHERE (((tblSavedFaxe s.FaxID)=" & fID
& "));"

DoCmd.SetWarnin gs False
DoCmd.RunSQL strSQL
DoCmd.SetWarnin gs True

Set objWord = GetObject(ProgD rive &
"\DACS\DocTempl ates\FaxMerge.d ot", "Word.Document" )

' ' Make Word visible.
' objWord.Applica tion.Visible = True

' Set the mail merge data source as a query on the DACS Database.

objWord.MailMer ge.OpenDataSour ce Name:=CurrentDb .Name,
LinkToSource:=T rue, Connection:="TA BLE TEMP_FaxPrint",
SQLStatement:=" SELECT * FROM [TEMP_FaxPrint]"

objWord.MailMer ge.Destination = wdSendToNewDocu ment

' Execute the mail merge.
objWord.MailMer ge.Execute

'Save the new document per pathname provided by user (docPath)
ActiveDocument. SaveAs docPath, , , , True

' Make Word visible.
objWord.Applica tion.Visible = True

' Close master document and release object variable
objWord.Close wdDoNotSaveChan ges
Set objWord = Nothing
=============== ======= END CODE =============== =============

The problem is that it works fine the FIRST time I do it (most of the
time). As soon as I try to do it again, the template gets opened in a
separate instance of Word in the background and it does not close.
Also, sometimes, a new instance of the Access app is spawned as well.

All that needs to happen is for the new word document to be opened
with the data from the one record table merged into the pre-defined
merge fields with the document already saved once. Then the user can
complete the document and click save again before they close Word --
at which point, Word should be closed and they should be right back at
the form they started from and there should be only one instance of
Access open.

Anyone have a clue what I'm missing?

Thanks for your help.

--LC