View Single Post
  #3   Report Post  
Wordmerger Wordmerger is offline
Junior Member
 
Posts: 6
Default

Hi Doug,

I can't find the MailMerge Event in the example on Grahams site.
Besides, I wonder if this would solve my problem.
The only thing I want is that a macro is executed automatically after the MailMerge (in the merged document).

I used the field MacroButton in the main document (a template), but this causes to run the macro in the main document.
I want the macro to run automatically in the merged document.

The merged document is always (?) based on Normal.dotm which doesn't contain the macro. It would be easier if the merged document would be based on the template of the main document, because in that situation I could create an AutoExec macro.
Now this is of course not an option since the merged document is based on Normal.dotm and I don't want all new documents to run this macro.

Until I find a better solution, I'll copy the macro to their Normal.dotm and ask my users to click a macro button after the mailmerge.
Not very elegant, but at least it works.

Thanks so far!



Quote:
Originally Posted by Doug Robbins - Word MVP View Post
You would need to use MailMerge Events to achieve what you are after
automatically.

You will find an example of their use in the add-in that you can download
from the following page of fellow MVP Graham Mayor's website:

http://www.gmayor.com/individual_merge_letters.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Wordmerger" wrote in message
...

Hello,
I created a Word (2007) template .dotm, that is merged with a data
file.
I merge to a new Word document.
The template contains a macro.

Word should execute the macro automatically in the new (merged)
document (to fix some layout issues).
The new document is not based on the template (as it should be), but on
Normal.dotm and the macro is not available in this document.

The macro should only start in the merged document and not in any other
documents.

Has anybody got a clue as to how to solve this problem?

Thanks in advance.




--
Wordmerger