View Single Post
 
Old 09-10-2018, 03:26 AM
MP1989 MP1989 is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Jun 2018
Posts: 9
MP1989 is on a distinguished road
Default VBA code not in module of new document produced by mail merge

Hi all,

Microsoft Word - Mail merge / VBA question

I have set up a document to perform mail merge, which works fine. However once I run the mail merge the VBA code that I have built into the document doesn't transfer across into the new document prepared by the mail merge. Does anyone have any ideas if this can be done?

To give you more information the VBA code works fine in the original document, but after performing mail merge the code is not in the module of the new document.

I have tried adding this to my normal document module and it worked on the new document produced by mail merge, however I need this to be available to other people and so need a solution built into the document.

Don't know if its possible to have a code that copies the current code into the normal module or if there is a better way to do this?

Thanks for your help in advance!
Reply With Quote