dirtychinch
06-03-2014, 05:35 AM
Afternoon all,
Following on from a previous thread, here (http://www.vbaexpress.com/forum/showthread.php?48989-Run-time-error-5922-Mail-Merge&p=305214) about mail merging from Excel to Word, I am having a different problem now.
I have a mail merge executing from within Excel. This is now working mostly beautifully, but we have a delinquent operator who insists on justifying things in documents. Although I'll get this sorted by a manager, I want to prevent her ever being able to justify the document.
I tried to protect the portions of the document that are pertinent, but if you have a file linked into a document for mail merging (my system using a kind of temp file, which means that the location of the source document for the Word document is always the same) then you cannot seem to lock the document.
So, is there anything I can do to enforce the formatting in this document?
Thanks in advance,
Jonathon
Following on from a previous thread, here (http://www.vbaexpress.com/forum/showthread.php?48989-Run-time-error-5922-Mail-Merge&p=305214) about mail merging from Excel to Word, I am having a different problem now.
I have a mail merge executing from within Excel. This is now working mostly beautifully, but we have a delinquent operator who insists on justifying things in documents. Although I'll get this sorted by a manager, I want to prevent her ever being able to justify the document.
I tried to protect the portions of the document that are pertinent, but if you have a file linked into a document for mail merging (my system using a kind of temp file, which means that the location of the source document for the Word document is always the same) then you cannot seem to lock the document.
So, is there anything I can do to enforce the formatting in this document?
Thanks in advance,
Jonathon