I've got a Mail Merge doc based on .xls via DDE. When manually openeing
the file i need to confirm that the sql will be run.
I've written a code to launch the mail merge doc from within Excel but
the problem is that by
launching it this way the sql gets disabled (no warning appears - i'm
not getting prompted at all - I've got no chance to confirm running of
that sql) and thus the Mail Merge gets disconnected
from the underlying .xls file... Any ideas how to keep the Mail Merge
running and connected to the .xls?

The code
Sub Open_MMerge()
Dim wrdApp As Word.Application
Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True
wrdApp.Documents.Open ("C:\Mail_merge.doc")
wrdApp.Activate
Set wrdApp = Nothing
End Sub


Thanks,


A.