>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
OK, a few things you should know.
Try quitting Word after you use it: wordObject.Quit
If you want to use an already open Word, use GetObject instead of CreateObject
There's an Automation bug when you try to execute more then one time a piece of code that use Word. I have a similar problem right now on a project and I'm pulling my hair of my head !!
I haven't found an solution yet.