Does anyone know a way to make a macro automatically run after a merge is
complete?

Hi ?B?TWljaGVsbGU=?=,

Does anyone know a way to make a macro automatically run after a merge is
complete?

Depends on the version of Word in question.

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 :-)

I'd like to be able to use it for 2000 and 2003.

"Cindy M -WordMVP-" wrote:

Hi ?B?TWljaGVsbGU=?=,

Does anyone know a way to make a macro automatically run after a merge is
complete?

Depends on the version of Word in question.

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 :-)

Hi Michelle,

I'd like to be able to use it for 2000 and 2003.

Sorry for the late reply, I was away...

With Word 2000 in the equation you have only one possibility:

Set up the macro to execute the merge, then the code you want to have run after
the merge is completed should immediately follow that. Word won't try to run
that code until the merge execution has been completed. Very roughly, like this:

Set doc = ActiveDocument
doc.MailMerge.Execute
doc.close wdDoNotSaveChanges
'The active document should now be the result
'It's probably the result, even if you don't close
'the main merge doc...


Does anyone know a way to make a macro automatically run after a merge is
complete?


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 :-)

Thanks anyway for responding. However, the merge is started from a database
program, so the macro has to run after.

"Cindy M -WordMVP-" wrote:

Hi Michelle,

I'd like to be able to use it for 2000 and 2003.

Sorry for the late reply, I was away...

With Word 2000 in the equation you have only one possibility:

Set up the macro to execute the merge, then the code you want to have run after
the merge is completed should immediately follow that. Word won't try to run
that code until the merge execution has been completed. Very roughly, like this:

Set doc = ActiveDocument
doc.MailMerge.Execute
doc.close wdDoNotSaveChanges
'The active document should now be the result
'It's probably the result, even if you don't close
'the main merge doc...


Does anyone know a way to make a macro automatically run after a merge is
complete?


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 :-)

Hi ?B?TWljaGVsbGU=?=,

However, the merge is started from a database
program, so the macro has to run after.

That shouldn't matter. The code in the database will also
pause until the merge has completed. Mail merge is not
asynchronous.

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
:-)