Hi Guys

I've created a Custom Mail Merge template which looks at an Excel spreadsheet.

The template also contains VBA to help the users once the merged document
has been created.

My problem is, whenever I carry out the 'Merge to New Document' feature, the
mail merge executes correctly but the new document looses it's association
with the Mail Merge template and restorts to Normal.dot as the associated
template.

Therefore, this means the users no longer have access to the VBA or the
custom toolbars that the Custom Mail Merge template should provide.

Is there away around this problem other than training our users to reattach
the custom template to the document?

All suggestions gratefully received

Regards

Alex

I've never worked out exactly what Word does with the attached template
during a merge, but in some cases the template seems to remain attached tot
he newly created document, in others it is attached but the macros are
unavailable, etc.

There are a couple of things you could try...
a. set up the macros you want in a template that you load as an addin - its
macros should then be available to everyone all the time. Requires some
admin work though
b. create a macro that does the merge and re-connects the output document
to the template. Attach the macro to a toolbar button and get the users to
use that to initiate the merge (you can try intercepting the existing
commands but personally I think it is confusing to alter the functions of
standard buttons).

BTW I would be wary of using /templates/ with an attached mail merge data
source.

Peter Jamieson

"Al" wrote in message
...
Hi Guys

I've created a Custom Mail Merge template which looks at an Excel
spreadsheet.

The template also contains VBA to help the users once the merged document
has been created.

My problem is, whenever I carry out the 'Merge to New Document' feature,
the
mail merge executes correctly but the new document looses it's association
with the Mail Merge template and restorts to Normal.dot as the associated
template.

Therefore, this means the users no longer have access to the VBA or the
custom toolbars that the Custom Mail Merge template should provide.

Is there away around this problem other than training our users to
reattach
the custom template to the document?

All suggestions gratefully received

Regards

Alex

Hi Peter

Thanks for the reply.

I was coming to the same conclusion as you, and will probably have to deploy
a mixture of the two methods to compensate for the offline / offsite workers
that store the company templates on their C: Drives so they dont have to log
on if they want to write a company document.

I found a Microsoft KB Article stating this was a known issue for Word 97,
guess it must have slipped their minds to fix it in later editions of Word
seeing I've found the problem in Word 97, 2000, XP and 2003.

What it has highlighted is that my Mail Merge templates only need the style
sheet, shell layout and the mailmerge fields in them so nice and simple, all
the usual extras I normally add to a template like AutoText, Key Assignments,
VBA etc can all be placed in the addin template.

Many Thanks for the help

Regards

Alex

"Peter Jamieson" wrote:

I've never worked out exactly what Word does with the attached template
during a merge, but in some cases the template seems to remain attached tot
he newly created document, in others it is attached but the macros are
unavailable, etc.

There are a couple of things you could try...
a. set up the macros you want in a template that you load as an addin - its
macros should then be available to everyone all the time. Requires some
admin work though
b. create a macro that does the merge and re-connects the output document
to the template. Attach the macro to a toolbar button and get the users to
use that to initiate the merge (you can try intercepting the existing
commands but personally I think it is confusing to alter the functions of
standard buttons).

BTW I would be wary of using /templates/ with an attached mail merge data
source.

Peter Jamieson

"Al" wrote in message
...
Hi Guys

I've created a Custom Mail Merge template which looks at an Excel
spreadsheet.

The template also contains VBA to help the users once the merged document
has been created.

My problem is, whenever I carry out the 'Merge to New Document' feature,
the
mail merge executes correctly but the new document looses it's association
with the Mail Merge template and restorts to Normal.dot as the associated
template.

Therefore, this means the users no longer have access to the VBA or the
custom toolbars that the Custom Mail Merge template should provide.

Is there away around this problem other than training our users to
reattach
the custom template to the document?

All suggestions gratefully received

Regards

Alex