[Wordmerger]

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.

[Doug Robbins - Word MVP]

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

[Wordmerger]

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!

Originally Posted by Doug Robbins - Word MVP

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

[Doug Robbins - Word MVP]

The mail merge events are used in the Add-in that you can down load from
that site.

Rather than asking people to copy something into their normal.dot template,
you could distribute a template that you have them save in the Word Startup
folder so that it becomes a global add-in. Then the macros in that template
will be available for use in all documents.

--
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
...

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!



Doug Robbins - Word MVP;471428 Wrote:
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 -




--
Wordmerger

[Wordmerger]

Thanks Doug,

I'm going to try this.

Originally Posted by Doug Robbins - Word MVP

The mail merge events are used in the Add-in that you can down load from
that site.

Rather than asking people to copy something into their normal.dot template,
you could distribute a template that you have them save in the Word Startup
folder so that it becomes a global add-in. Then the macros in that template
will be available for use in all documents.

--
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
...

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!



Doug Robbins - Word MVP;471428 Wrote:
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 -




--
Wordmerger

[tech101]

I am a new member here. But pls visit our homepage URL through my Signature and URL Link....