A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Protecting a merged document.



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2004, 08:41 PM
nvchaz
external usenet poster
 
Posts: n/a
Default Protecting a merged document.

I have a client who wishes to allow employees to perform a mail merge and yet not be allowed to change the body of the document. Normally I'd do this sort of thing in Access but the client doesn't have the licenses. Protecting for forms prevents the merge. Setting the form as read-only is not sufficient because a particular instance of the merge can be changed. Any way to block changes in the body of a merged document?

Thanks!!!
  #2  
Old June 7th, 2004, 09:59 PM
Charles Kenyon
external usenet poster
 
Posts: n/a
Default Protecting a merged document.

Word is not designed for the level of security that you can achieve with
Access. Even if you protect for forms, it is relatively easy to circumvent.
However, you could do the merge using a macro that first links to the
datafile and merges and then protects for forms or (prints and deletes).
Also relatively easy to circumvent by blocking macros. However, if it is the
macro that accesses the data file, it may be enough.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"nvchaz" wrote in message
...
I have a client who wishes to allow employees to perform a mail merge and

yet not be allowed to change the body of the document. Normally I'd do this
sort of thing in Access but the client doesn't have the licenses. Protecting
for forms prevents the merge. Setting the form as read-only is not
sufficient because a particular instance of the merge can be changed. Any
way to block changes in the body of a merged document?

Thanks!!!



  #3  
Old June 7th, 2004, 10:34 PM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default Protecting a merged document.

Use a macro to unprotect the document, execute the merge and then protect
the document created by executing the merge and reprotect the mailmerge main
document.

Dim Source As Document, Result As Document
Set Source = ActiveDocument
Source.Unprotect
With Source.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With
Set Result = ActiveDocument
Result.Protect wdAllowOnlyFormFields
Source.Protect wdAllowOnlyFormFields


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"nvchaz" wrote in message
...
I have a client who wishes to allow employees to perform a mail merge and

yet not be allowed to change the body of the document. Normally I'd do this
sort of thing in Access but the client doesn't have the licenses. Protecting
for forms prevents the merge. Setting the form as read-only is not
sufficient because a particular instance of the merge can be changed. Any
way to block changes in the body of a merged document?

Thanks!!!


  #4  
Old June 8th, 2004, 04:26 PM
nvchaz
external usenet poster
 
Posts: n/a
Default Protecting a merged document.

Thanks guys you are great - I'll try it!

----- Doug Robbins - Word MVP wrote: -----

Use a macro to unprotect the document, execute the merge and then protect
the document created by executing the merge and reprotect the mailmerge main
document.

Dim Source As Document, Result As Document
Set Source = ActiveDocument
Source.Unprotect
With Source.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With
Set Result = ActiveDocument
Result.Protect wdAllowOnlyFormFields
Source.Protect wdAllowOnlyFormFields


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"nvchaz" wrote in message
...
I have a client who wishes to allow employees to perform a mail merge and

yet not be allowed to change the body of the document. Normally I'd do this
sort of thing in Access but the client doesn't have the licenses. Protecting
for forms prevents the merge. Setting the form as read-only is not
sufficient because a particular instance of the merge can be changed. Any
way to block changes in the body of a merged document?
Thanks!!!


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.