Can I build a form that can be completed using a letter merge?

[auda19]

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.

 

[Doug Robbins - Word MVP]

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

 

[Kathy Webster]

Where can I read more on this technique?

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

 

[Doug Robbins - Word MVP]

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