 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2007Mail Merge and protection
Hi, I have a mail merge document in MS Word 2003 in which I use several form fields to be filled manually as well. When a user opens the document (well, the system generates the document), they have to enable macros for the merge to work, once the data is retrieved from external source and the document is merged, then I use VBA to set the protection: ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True, Password:="My_PassWord" Now the problem is that after this, the users are not able to edit the form fields, although I have used wdAllowOnlyFormFields. Form fields and mail merge are incompatible and the fields will will not survive a merge. You will have to think of some other way of inserting your data eg ASK fields?  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi, > [quoted text clipped - 11 lines] > Now the problem is that after this, the users are not able to edit > the form fields, although I have used wdAllowOnlyFormFields. Hi Graham, Assuming the ASK field and any cross-references to it survives the merge, I can see all sorts of problems arising with the cross-references trying to get data from multiple instances of ASK fields that all set the same bookmark. Invariably, they'll all end up pointing to the last ASK field. Perhaps a user form would be better suited - especially since the OP is already using vba. Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- > Form fields and mail merge are incompatible and the fields will will not survive a merge. You will have to think of some other way > of inserting your data eg ASK fields? [quoted text clipped - 14 lines] >> Now the problem is that after this, the users are not able to edit >> the form fields, although I have used wdAllowOnlyFormFields. Agreed - I don't like ASK fields at all. It was merely the first thing that came out as a possible alternative - and then only if the same data applied to all the records.. Nor do I like the idea of adding data per record on the fly - much better to modify the data source. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi Graham, > [quoted text clipped - 32 lines] >>> Now the problem is that after this, the users are not able to edit >>> the form fields, although I have used wdAllowOnlyFormFields. Hi macropod, Thanks for the reply. Can you elaborate on using user forms? Regards, Hameed > Hi Graham, > [quoted text clipped - 23 lines] > >> Now the problem is that after this, the users are not able to edit > >> the form fields, although I have used wdAllowOnlyFormFields. Hi Hameed, See: http://word.mvps.org/FAQs/Userforms/index.htm Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- > Hi macropod, > [quoted text clipped - 33 lines] >> >> Now the problem is that after this, the users are not able to edit >> >> the form fields, although I have used wdAllowOnlyFormFields. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.