General information
Title:
Access - Word Automation. (-2147023174 Automation Error)
Hi all !
Here my problem : I have a Access database and a form. On the form, I have a button. When I click this button I take active this code.
(Mail Merge Process). When I execute the first time this code everything go right the user close the word application after but the problem appear when i try to execute a second time. The wordtest is created successful but mymerge give this error.
Here the code :
Dim mymerge As word.MailMerge
Dim wordTest As Object
Set wordTest = CreateObject("word.basic")
With wordTest
.fileopen StrFileName
.appmaximize
Set mymerge = ActiveDocument.MailMerge
mymerge.Execute
End With
Set mymerge = Nothing
Set wordTest = Nothing
End If
Thank to all
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only