If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form text fields are disappearing during a merge to new document.
We would like to create a form that has some merged information on it, as
well as check boxes, dropdowns and form text fields. After the merge to a new document, we would save it as a template and turn on document protection with a password. The recipient could then fill in the form, using the check boxes, drop-downs and text fields. However, when I merge the document, the form text fields disappear, whereas the check boxes and dropsowns don't. How can I make the form text fields survive the merge? We are at Word 2003 SP1. |
#3
|
|||
|
|||
Form text fields are disappearing during a merge to new document.
As Doug said, the two features are not designed to work together. However,
if you are using merge to fill in data from only one record, there is a workaround. What, exactly, are you doing? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Trevor Drew" Trevor wrote in message ... We would like to create a form that has some merged information on it, as well as check boxes, dropdowns and form text fields. After the merge to a new document, we would save it as a template and turn on document protection with a password. The recipient could then fill in the form, using the check boxes, drop-downs and text fields. However, when I merge the document, the form text fields disappear, whereas the check boxes and dropsowns don't. How can I make the form text fields survive the merge? We are at Word 2003 SP1. |
#4
|
|||
|
|||
Form text fields are disappearing during a merge to new docume
We were trying to merge multiple records - about 8 per document - into a
document that would contain a mix of filled in fields (from our data) and fields that the user would fill in. There must be the capability to write into text boxes as well as to check boxes. This is being done currently by printing a form and filling it in the old fashioned way. Even though the filled in form doesn't need to find its way back into a database, some users of the form thought it might be nice to have an electronic version. The users all have wireless laptops, but we didn't have the time to whip up a web form. The first need for it was this past Saturday. A quick modification of the existing Word document seemed like the way to go. The fact that drop-downs and check boses survived the merge gave me hope. I thought there might be some way to make the text boxes survive as well. Since then, I have experimented a bit with a macro to insert text form fields into the merged document in place of some text phrase that could be put in the master wherever we need a form field. Though a bit of a kludge, it could work. Thanks for your help. "Charles Kenyon" wrote: As Doug said, the two features are not designed to work together. However, if you are using merge to fill in data from only one record, there is a workaround. What, exactly, are you doing? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Trevor Drew" Trevor wrote in message ... We would like to create a form that has some merged information on it, as well as check boxes, dropdowns and form text fields. After the merge to a new document, we would save it as a template and turn on document protection with a password. The recipient could then fill in the form, using the check boxes, drop-downs and text fields. However, when I merge the document, the form text fields disappear, whereas the check boxes and dropsowns don't. How can I make the form text fields survive the merge? We are at Word 2003 SP1. |
#5
|
|||
|
|||
Form text fields are disappearing during a merge to new docume
If all of your records appear on one page, you can do my workaround,
otherwise it would require one merge per record. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Trevor Drew" wrote in message ... We were trying to merge multiple records - about 8 per document - into a document that would contain a mix of filled in fields (from our data) and fields that the user would fill in. There must be the capability to write into text boxes as well as to check boxes. This is being done currently by printing a form and filling it in the old fashioned way. Even though the filled in form doesn't need to find its way back into a database, some users of the form thought it might be nice to have an electronic version. The users all have wireless laptops, but we didn't have the time to whip up a web form. The first need for it was this past Saturday. A quick modification of the existing Word document seemed like the way to go. The fact that drop-downs and check boses survived the merge gave me hope. I thought there might be some way to make the text boxes survive as well. Since then, I have experimented a bit with a macro to insert text form fields into the merged document in place of some text phrase that could be put in the master wherever we need a form field. Though a bit of a kludge, it could work. Thanks for your help. "Charles Kenyon" wrote: As Doug said, the two features are not designed to work together. However, if you are using merge to fill in data from only one record, there is a workaround. What, exactly, are you doing? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Trevor Drew" Trevor wrote in message ... We would like to create a form that has some merged information on it, as well as check boxes, dropdowns and form text fields. After the merge to a new document, we would save it as a template and turn on document protection with a password. The recipient could then fill in the form, using the check boxes, drop-downs and text fields. However, when I merge the document, the form text fields disappear, whereas the check boxes and dropsowns don't. How can I make the form text fields survive the merge? We are at Word 2003 SP1. |
#6
|
|||
|
|||
Form text fields are disappearing during a merge to new docume
The merged document is two pages per record. Sounds like a post merge macro
or a return to paper forms is in order. Thanks for your help. "Charles Kenyon" wrote: If all of your records appear on one page, you can do my workaround, otherwise it would require one merge per record. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Trevor Drew" wrote in message ... We were trying to merge multiple records - about 8 per document - into a document that would contain a mix of filled in fields (from our data) and fields that the user would fill in. There must be the capability to write into text boxes as well as to check boxes. This is being done currently by printing a form and filling it in the old fashioned way. Even though the filled in form doesn't need to find its way back into a database, some users of the form thought it might be nice to have an electronic version. The users all have wireless laptops, but we didn't have the time to whip up a web form. The first need for it was this past Saturday. A quick modification of the existing Word document seemed like the way to go. The fact that drop-downs and check boses survived the merge gave me hope. I thought there might be some way to make the text boxes survive as well. Since then, I have experimented a bit with a macro to insert text form fields into the merged document in place of some text phrase that could be put in the master wherever we need a form field. Though a bit of a kludge, it could work. Thanks for your help. "Charles Kenyon" wrote: As Doug said, the two features are not designed to work together. However, if you are using merge to fill in data from only one record, there is a workaround. What, exactly, are you doing? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Trevor Drew" Trevor wrote in message ... We would like to create a form that has some merged information on it, as well as check boxes, dropdowns and form text fields. After the merge to a new document, we would save it as a template and turn on document protection with a password. The recipient could then fill in the form, using the check boxes, drop-downs and text fields. However, when I merge the document, the form text fields disappear, whereas the check boxes and dropsowns don't. How can I make the form text fields survive the merge? We are at Word 2003 SP1. |
#7
|
|||
|
|||
Form text fields are disappearing during a merge to new docume
could you please tell me what the workaround is? I think I may be able to use
it. "Charles Kenyon" wrote: As Doug said, the two features are not designed to work together. However, if you are using merge to fill in data from only one record, there is a workaround. What, exactly, are you doing? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Trevor Drew" Trevor wrote in message ... We would like to create a form that has some merged information on it, as well as check boxes, dropdowns and form text fields. After the merge to a new document, we would save it as a template and turn on document protection with a password. The recipient could then fill in the form, using the check boxes, drop-downs and text fields. However, when I merge the document, the form text fields disappear, whereas the check boxes and dropsowns don't. How can I make the form text fields survive the merge? We are at Word 2003 SP1. |
#8
|
|||
|
|||
Form text fields are disappearing during a merge to new docume
With the data from the required record displayed, run the following macro
Dim afield As Field For Each afield In ActiveDocument.Fields If afield.Type = wdFieldMergeField Then afield.Unlink End If Next afield ActiveDocument.Protect wdAllowOnlyFormFields Dialogs(wdDialogFileSaveAs).Show Enter a new filename when the FileSaveAs dialog appears as running this macro will "destroy" the mergefields in the mailmerge main document. -- 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 "bambicats7" wrote in message ... could you please tell me what the workaround is? I think I may be able to use it. "Charles Kenyon" wrote: As Doug said, the two features are not designed to work together. However, if you are using merge to fill in data from only one record, there is a workaround. What, exactly, are you doing? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Trevor Drew" Trevor wrote in message ... We would like to create a form that has some merged information on it, as well as check boxes, dropdowns and form text fields. After the merge to a new document, we would save it as a template and turn on document protection with a password. The recipient could then fill in the form, using the check boxes, drop-downs and text fields. However, when I merge the document, the form text fields disappear, whereas the check boxes and dropsowns don't. How can I make the form text fields survive the merge? We are at Word 2003 SP1. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Add checkboxes with macro in Merge document? | Bryan L | Tables | 3 | October 19th, 2005 04:05 PM |
Word crashing upon re-use of a template | jenwren | General Discussion | 5 | August 24th, 2005 11:59 PM |
Populate Merge Fields via VB.NET | ben | Mailmerge | 5 | June 21st, 2005 05:43 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 05:11 AM |