Solved: Changing Templates

[mdmackillop]

I have a number of Word templates. I'm looking to create mailmerge documents from these and include further automation.
I've created a new document based on the template, and made it mail merge, I've added a simple Document Open macro to run the code which is in my Normal.dot (at present), but this is not being found because (I think) the document is looking to the original template for the code.
Somehow, I need to remove this link. I can't just delete the template, which is stored on the server and still in use, until everything is up and running.
Pasting the document into a new document isn't working, as the font sizes are changing.
Any other ideas?

[lucas]

What if you put the code in document new of the template so it would run when the template is cloned?

[mdmackillop]

New documents will be created from the mailmerge document, so the templates all become superfluous.

[lucas]

how about calling the sub in the normal.dot directly
Application.Run "'My Document.doc'!ThisModule.ThisProcedure"

[mdmackillop]

Got it! :doh:
Copy the templates to my PC, create the new documents from the templates here, then delete them!

[lucas]

Good deal Malcolm....thought I was going to be helpful there for a minute but probably didn't come up with anything you hadn't thought of:bow:

[mdmackillop]

All ideas welcome. They help stimulate the thought process!