Can I build a form that can be completed using a letter merge? auda19 4/30/2007 3:14:03 PM I would like to put together a form where a letter merge can be used to complete the fields. The main problem is that I would like to lock down the remainder of the conmtent so users cannot change it. I need to use the letter merge because often times users need to fill out the forms for 20+ people at a time.

Re: Can I build a form that can be completed using a letter merge? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 4/30/2007 4:33:07 PM Mail Merge and Document Protection are mutually exclusive. It would however be possible to use VBA code to accomplish much the same thing using document variables and docvariable fields rather than mail merge fields. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "auda19" <auda19[ at ]discussions.microsoft.com> wrote in message news:79F5ABE4-BCA4-42F6-B661-B2095A9FEF04[ at ]microsoft.com... [Quoted Text] >I would like to put together a form where a letter merge can be used to > complete the fields. The main problem is that I would like to lock down > the > remainder of the conmtent so users cannot change it. I need to use the > letter merge because often times users need to fill out the forms for 20+ > people at a time.

Re: Can I build a form that can be completed using a letter merge? "Kathy Webster" <slickdock[ at ]yahoo.com> 5/9/2007 11:25:56 PM Where can I read more on this technique? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> wrote in message news:eAq59U0iHHA.688[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > Mail Merge and Document Protection are mutually exclusive. It would > however be possible to use VBA code to accomplish much the same thing > using document variables and docvariable fields rather than mail merge > fields. > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "auda19" <auda19[ at ]discussions.microsoft.com> wrote in message > news:79F5ABE4-BCA4-42F6-B661-B2095A9FEF04[ at ]microsoft.com... >>I would like to put together a form where a letter merge can be used to >> complete the fields. The main problem is that I would like to lock down >> the >> remainder of the conmtent so users cannot change it. I need to use the >> letter merge because often times users need to fill out the forms for 20+ >> people at a time. > >

Re: Can I build a form that can be completed using a letter merge? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/10/2007 7:45:34 AM I don't know of a source where I can point you to read up on this specific application of VBA, but what you would do is insert DOCVARIABLE fields in the letter in the locations where you want the merged information to appear, you would protect that document for forms, and then save it as a template. Then you would have some code that opened the data source and iterated through the records in the data source, creating a new document from the template mentioned above and using the information from each field in the current record to set the values of the document variables that correspond to each of the DOCVARIABLE fields and after doing that, it would update the fields in the document so that the information is displayed in those fields and then save the document and close it before going on to the next record in the data source and repeating the procedure. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Kathy Webster" <slickdock[ at ]yahoo.com> wrote in message news:46425886$0$27113$4c368faf[ at ]roadrunner.com... [Quoted Text] > Where can I read more on this technique? > > "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> wrote in message > news:eAq59U0iHHA.688[ at ]TK2MSFTNGP03.phx.gbl... >> Mail Merge and Document Protection are mutually exclusive. It would >> however be possible to use VBA code to accomplish much the same thing >> using document variables and docvariable fields rather than mail merge >> fields. >> >> -- >> Hope this helps. >> >> Please reply to the newsgroup unless you wish to avail yourself of my >> services on a paid consulting basis. >> >> Doug Robbins - Word MVP >> >> "auda19" <auda19[ at ]discussions.microsoft.com> wrote in message >> news:79F5ABE4-BCA4-42F6-B661-B2095A9FEF04[ at ]microsoft.com... >>>I would like to put together a form where a letter merge can be used to >>> complete the fields. The main problem is that I would like to lock down >>> the >>> remainder of the conmtent so users cannot change it. I need to use the >>> letter merge because often times users need to fill out the forms for >>> 20+ >>> people at a time. >> >> > >