Mail merge in a protected form?

J

jrh

I have a Transmittal Letter form that is protected to
prevent users from altering it. Now I want to add mail
merge fields from my Access database but mail merge
doesn't work when the form is protected. Is there a way
to get mail merge to work in a protected form?
Thanks.
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

No, you will have to remove the protection to execute a mailmerge. You can
use the following code in a macro to do this

ActiveDocument.Unprotect
ActiveDocument.MailMerge.Execute
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset



--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top