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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

auda19 - 30 Apr 2007 16:14 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 30 Apr 2007 17:33 GMT

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.

Signature

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

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

Reply to this Message

Kathy Webster - 10 May 2007 00:25 GMT

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
[quoted text clipped - 7 lines]
>> letter merge because often times users need to fill out the forms for 20+
>> people at a time.

Reply to this Message

Doug Robbins - Word MVP - 10 May 2007 08:45 GMT

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.

Signature

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

> Where can I read more on this technique?
>
[quoted text clipped - 10 lines]
>>> 20+
>>> people at a time.

Reply to this Message

Rate this thread: