Failing Mail Merge Automation

[Frank]

I've been trying to produce a mail merge that includes a chart from Excel
that must be recalculated & updated for each recipient of the merge. I've
been trying to use the approach described in
http://support.microsoft.com/kb/285333, understanding that I have to adapt
some pieces for Office 2007.

None of my code appears to be accessed during the mail merge.
I recieved syntax errors and the like as I was massaging the code for my
custom methods, but no stops at breakpoints (no execution at all apparently,
since even the "stop" command fails to halt execution).

I have software development experience, but very limited VB exposure, so I'm
likely doing something (or failing to do something) extremely basic in
setup...

I appreciate any help,
F/C

 

[Cindy M.]

Hi Frank,

I've been trying to produce a mail merge that includes a chart from Excel
that must be recalculated & updated for each recipient of the merge. I've
been trying to use the approach described in
http://support.microsoft.com/kb/285333, understanding that I have to adapt
some pieces for Office 2007.

None of my code appears to be accessed during the mail merge.
I recieved syntax errors and the like as I was massaging the code for my
custom methods, but no stops at breakpoints (no execution at all apparently,
since even the "stop" command fails to halt execution).

I have software development experience, but very limited VB exposure, so I'm
likely doing something (or failing to do something) extremely basic in
setup...

I worked this out, even published it... And it turned out very few people could
use it. Apparently, the MailMergeBeforeRecordMerge gets all confused if there
aren't enough resources available for the code it's executing to finish before
mail merge insists on processing the next record. So I never saw any problems,
but others found mail merge just gave up and stopped after a certain point.

So, the only reliable way I know of to do this is to either not use mail merge
(just create the result with your code from scratch), or process the result
document after mail merge has completed. Given the intricacy of the latter, I
personally prefer the former even though it sounds like more work.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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