Word Mail-Merge Addin

[woodfoot]

I have created a commandbar in Word with a 1/2 dozen buttons that dod various
mail merges. 3 of the 6 work fine, they are Letters and memos mail merges
from data coming in from a linked Oracle server thru sql2005. The remaining
3 are causing me problems. Two of three do a mail-merge the data from a SQL
2005 table and the other one does it from the linked Oracle server. All 3 of
these as they are pulling in the data, spawn another Word document window
that does a duplicate mail merge.

So when the process is done, I have 3 instances of Word. The main document
one and identical mail-merged document windows.

Why and how I can stop it from doing 2 mail-merges on one buttton click?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?d29vZGZvb3Q=?=,

I have created a commandbar in Word with a 1/2 dozen buttons that dod various
mail merges. 3 of the 6 work fine, they are Letters and memos mail merges
from data coming in from a linked Oracle server thru sql2005. The remaining
3 are causing me problems. Two of three do a mail-merge the data from a SQL
2005 table and the other one does it from the linked Oracle server. All 3 of
these as they are pulling in the data, spawn another Word document window
that does a duplicate mail merge.

So when the process is done, I have 3 instances of Word. The main document
one and identical mail-merged document windows.

Why and how I can stop it from doing 2 mail-merges on one buttton click?

Since you don't show or discuss any of the code, it's impossible to say. But
since this isn't something I've ever seen Word just "do", I'm guessing the code
in question contain .Execute twice, or that the main merge documents contain
macro code that's causing the merge to execute.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail