Reply
 
Thread Tools Display Modes
  #1   Report Post  
Wordmerger Wordmerger is offline
Junior Member
 
Posts: 6
Unhappy start macro (in merged doc) after mailmerge

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default start macro (in merged doc) after mailmerge

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


  #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
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default start macro (in merged doc) after mailmerge

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


  #5   Report Post  
Wordmerger Wordmerger is offline
Junior Member
 
Posts: 6
Default

Thanks Doug,

I'm going to try this.


Quote:
Originally Posted by Doug Robbins - Word MVP View Post
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


  #6   Report Post  
tech101 tech101 is offline
Junior Member
 
Posts: 1
Default

I am a new member here. But pls visit our homepage URL through my Signature and URL Link....
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-start Macro Frank[_5_] New Users 2 March 6th 10 06:07 PM
Mailmerge: not all data merged Regimra Mailmerge 1 July 1st 09 02:32 PM
Mailmerge merged field format Liz T NN14 Mailmerge 2 November 19th 06 09:35 AM
macro start up oe New Users 8 August 17th 05 08:31 PM
Macro to start up Document Map Mary Z Microsoft Word Help 1 June 8th 05 12:51 AM


All times are GMT +1. The time now is 12:54 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"