Information générale
Titre:
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement