Access & Word 97 Mail Merge

[slickpg]

I have created a mail merge app that is working but when passing data from an Access form to the Word Document, the Word document does not become visible until mouse movement is detected. Any ideas anybody????

 

[scriverb]

I have done the same thing in an app and am not having anything like this happen. Here is the code that I use to open WORD and execute the merging of a template:

Dim MyAppID as Variant
Dim vFormName as string
vFormName = "[i]wordtemplatename.dot[/i]"
MyAppID = Shell("c:\program files\microsoft office\office\winword.exe /t" & vFormName, vbMaximizedFocus) ' Open MSWord 
AppActivate MyAppID ' Activate Microsoft Word.

Maybe the last command to activitate the word window is what you are lacking.


Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[slickpg]

Some time after submitting my posting, I finally figured out that our network performance was extremely slow and response improved after lunch; also discovered that the mail merge documents need to use ODBC instead of the DDE which also stopped the opening of a second Access window

Thanks for the previous response; i will take a close look at it

So my app is working and I'm on my way !!!