Automatically copying VBA to mail merged document

Hello all,
I have a set of code that colours cells based on their values (MMY/MMI/MMN), to show students whether they have completed a task or not. The code is stored in the mail merge document itself, but when I run the merge and the new 'letters' are created the code has to be manually copied into the VBA window. Is there a way of automatically inserting the VBA into the mail merged letters as some non-techhies will be using this system!

Many thanks

Luke

Please Login or Register  to view this content.

Update 22/5 - cross posted at http://www.vbaexpress.com/forum/show...762#post309762

You might have gotten help rather earlier if you'd posted in the correct forum. Given that it's a Word macro, you should have posted in http://www.excelforum.com/word-programming-vba-macros/. See my reply at vbaexpress.