Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
nine digit zip code won't print in mail merge Durham Excel Discussion (Misc queries) 11 July 1st 08 12:34 PM
How can I get excel to mail merge zip codes plus 4 correctly? Kathy at Sauder Feeds Excel Worksheet Functions 1 June 30th 05 11:21 AM
help removing duplicates for mail merge jeff quigley Excel Discussion (Misc queries) 0 June 13th 05 08:05 PM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 09:53 PM
mail merge from excel Vass Excel Discussion (Misc queries) 3 January 7th 05 05:36 PM


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"