Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code launches Mail Merge but disables the Mail Merge
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. Now i've written a code to launch the mail merge doc from 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) 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nine digit zip code won't print in mail merge | Excel Discussion (Misc queries) | |||
How can I get excel to mail merge zip codes plus 4 correctly? | Excel Worksheet Functions | |||
help removing duplicates for mail merge | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
mail merge from excel | Excel Discussion (Misc queries) |