Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can I build a form that can be completed using a letter merge?
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can I build a form that can be completed using a letter merge?
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" wrote in message ... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can I build a form that can be completed using a letter merge?
Where can I read more on this technique?
"Doug Robbins - Word MVP" wrote in message ... 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" wrote in message ... 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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can I build a form that can be completed using a letter merge?
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" wrote in message ... Where can I read more on this technique? "Doug Robbins - Word MVP" wrote in message ... 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 pulls up my mail merge template, but doesn't complete the merge into a new Form Letter 1 | Mailmerge | |||
Widow/orphan removal form completed document | Microsoft Word Help | |||
prevent form being completed until check box has been selected | Microsoft Word Help | |||
merge form letter | Mailmerge | |||
Prevent moving on to next field in a form unless it is completed. | Microsoft Word Help |