Can we do a mail merge when a document is protected?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb - 10 Jul 2006 20:43 GMT

We have a variety of "form letters" that are used throughout the
organization, and I would like to be able to protect the body of the letter,
but allow the user to merge from a data table. IE Name, Address, etc can not
be locked.

I tried protecting the document and each of the options in 2002 created a
further problem. Track changes of course show the merged data as changes in
Red. "Comments" won't allow me to use the merge fields and "forms" with only
the correct sections highlighted greys out the option to mail merge the
document.

Any suggestions?

Reply to this Message

Peter Jamieson - 11 Jul 2006 12:22 GMT

As far as I know the only way to do this is to use protected sections and
provide the user with a macro (and button to execute it) that
a. unprotects the protected sections
b. performs the merge
c. reprotects the protected sectins (or perhaps just closes the mergemain
document without saving changes).

Broadly speaking that doesn't offer much protection because the code has to
provide any password you might have used to protect the document, but it's
/a/ way to do it.

Peter Jamieson

> We have a variety of "form letters" that are used throughout the
> organization, and I would like to be able to protect the body of the
[quoted text clipped - 12 lines]
>
> Any suggestions?

Reply to this Message