Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge with an "online form" problem with text box
I have created an online form that utilizes check boxes, text boxes, and a
combo box. The data source is an excel worksheet. After I merge the data into the form, I protect the form. None of my text boxes will accept focus. The check boxes work fine and the combo box works fine. I will appreciate any help. Thank you. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge with an "online form" problem with text box
Those to features - Mail Merge and Online Forms are not compatible. There
is a work around, but it involves the use of VBA to create a new document for each record in the data source and getting the information from Excel and inserting it into each of those new documents. Are you up to that? -- 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 "Jessica Jones" Jessica wrote in message news I have created an online form that utilizes check boxes, text boxes, and a combo box. The data source is an excel worksheet. After I merge the data into the form, I protect the form. None of my text boxes will accept focus. The check boxes work fine and the combo box works fine. I will appreciate any help. Thank you. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge with an "online form" problem with text box
Yes, this is how it works. MailMerge and Online forms are mutually
incompatible. If it is protected you can't merge. After you merge, your fields are gone. Part of this, I'm sure, has to do with using bookmarks for form fields. Bookmarks are lost in a mailmerge because they need to be unique. How many records are you merging into your form? -- 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. "Jessica Jones" Jessica wrote in message news I have created an online form that utilizes check boxes, text boxes, and a combo box. The data source is an excel worksheet. After I merge the data into the form, I protect the form. None of my text boxes will accept focus. The check boxes work fine and the combo box works fine. I will appreciate any help. Thank you. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge with an "online form" problem with text box
I am up for trying anything. I have minor VBA and VB experience. Right now,
we have about 25 records that I need to merge. Taking the information out of one program and using excel really only a sa middleware to add some more fields to be able to collect some information. Then, I wanted the online form to save the information as a delimited text file to be able to import into access. I know this is a very long way around, most would say, import it into access directly and use those forms. BUT, the people who will do the data entry are very afraid of access. Thanks for your rapid responses. I really appreciate your time. I knew there had to be a reason my text boxes were misbehaving. Why do the combo boxes and check boxes still work? "Charles Kenyon" wrote: Yes, this is how it works. MailMerge and Online forms are mutually incompatible. If it is protected you can't merge. After you merge, your fields are gone. Part of this, I'm sure, has to do with using bookmarks for form fields. Bookmarks are lost in a mailmerge because they need to be unique. How many records are you merging into your form? -- 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. "Jessica Jones" Jessica wrote in message news I have created an online form that utilizes check boxes, text boxes, and a combo box. The data source is an excel worksheet. After I merge the data into the form, I protect the form. None of my text boxes will accept focus. The check boxes work fine and the combo box works fine. I will appreciate any help. Thank you. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge with an "online form" problem with text box
My guess is that the combo boxes and checkboxes you have working are
inserted using the Controls Toolbox rather than the forms toolbar. The reason I asked about the number of records is that I use a work-around for working with a single record, but it won't work with 25. Try Doug's solution. -- 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. "Jessica Jones" wrote in message ... I am up for trying anything. I have minor VBA and VB experience. Right now, we have about 25 records that I need to merge. Taking the information out of one program and using excel really only a sa middleware to add some more fields to be able to collect some information. Then, I wanted the online form to save the information as a delimited text file to be able to import into access. I know this is a very long way around, most would say, import it into access directly and use those forms. BUT, the people who will do the data entry are very afraid of access. Thanks for your rapid responses. I really appreciate your time. I knew there had to be a reason my text boxes were misbehaving. Why do the combo boxes and check boxes still work? "Charles Kenyon" wrote: Yes, this is how it works. MailMerge and Online forms are mutually incompatible. If it is protected you can't merge. After you merge, your fields are gone. Part of this, I'm sure, has to do with using bookmarks for form fields. Bookmarks are lost in a mailmerge because they need to be unique. How many records are you merging into your form? -- 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. "Jessica Jones" Jessica wrote in message news I have created an online form that utilizes check boxes, text boxes, and a combo box. The data source is an excel worksheet. After I merge the data into the form, I protect the form. None of my text boxes will accept focus. The check boxes work fine and the combo box works fine. I will appreciate any help. Thank you. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge with an "online form" problem with text box
Rather than having to have the macro interact with Excel, it will be easier
if you create a Catalog (or in Word XP and later, it is called "Directory") type mailmerge main document in which you have a one row table into the cells of which you insert the mergefields from your Excel datasource. When you execute that merge to a new document, that document will contain a table with a row of data for each record in the datasource. In the code below, it is assumed that you save that document as C:\Documents and Settings\[User Name]\My Documents\My Data Sources\DataDoc.doc"). Now you need to create or save your form as a template and inplace of mergefields in that template, insert { DOCVARIABLE varname } fields. In the code below, it is assumed that those fields are named var1, var2, ... varj where you will have the { DOCVARIABLE var1 } field in the location where the data from the first column of the table in the document that you saved as DataDoc is required and the { DOCVARIABLE var2 } field in the location where the data from the second column of the table is required, and so on for each field in the datasource. Protect the template for Forms and then save and close it and also the DataDoc document. Now when you run the following macro, it will create a new document from the template for each record in the datasource, with the data from each record in the datasource inserted into it. Each of those documents will be saved with the filename myformdoc1, myformdoc2, etc, but you can have the newdoc in the filename replaced by anything else that you might want to use by inserting whatever that is in the line "newdoc.SaveAs "myformdoc" & i" in place of the myformdoc. Dim datasource As Document, newdoc As Document, datarange As Range, i As Long, j As Long, datatable As Table Set datasource = Documents.Open("C:\Documents and Settings\[User Name]\My Documents\My Data _ Sources\DataDoc.doc") Set datatable = datasource.Tables(1) For i = 1 To datasource.Tables(1).Rows.Count Set newdoc = Documents.Add("C:\Documents and Settings\Doug Robbins\Application _ Data\Microsoft\Templates\DataForm.dot") For j = 1 To datatable.Columns.Count Set datarange = datatable.Cell(i, j).Range datarange.End = datarange.End - 1 newdoc.Variables("varj").Value = datarange.Text Next j newdoc.Fields.Update newdoc.SaveAs "myformdoc" & i newdoc.Close Next i -- 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 "Jessica Jones" wrote in message ... I am up for trying anything. I have minor VBA and VB experience. Right now, we have about 25 records that I need to merge. Taking the information out of one program and using excel really only a sa middleware to add some more fields to be able to collect some information. Then, I wanted the online form to save the information as a delimited text file to be able to import into access. I know this is a very long way around, most would say, import it into access directly and use those forms. BUT, the people who will do the data entry are very afraid of access. Thanks for your rapid responses. I really appreciate your time. I knew there had to be a reason my text boxes were misbehaving. Why do the combo boxes and check boxes still work? "Charles Kenyon" wrote: Yes, this is how it works. MailMerge and Online forms are mutually incompatible. If it is protected you can't merge. After you merge, your fields are gone. Part of this, I'm sure, has to do with using bookmarks for form fields. Bookmarks are lost in a mailmerge because they need to be unique. How many records are you merging into your form? -- 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. "Jessica Jones" Jessica wrote in message news I have created an online form that utilizes check boxes, text boxes, and a combo box. The data source is an excel worksheet. After I merge the data into the form, I protect the form. None of my text boxes will accept focus. The check boxes work fine and the combo box works fine. I will appreciate any help. Thank you. |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge with an "online form" problem with text box
Good Monday Morning!
Just to keep the information correct, I wanted to respond to and state that I definitely used the forms toobar and not the Controls toolbox with the checkboxes and combo box. That is really what has me so frustrated. Thanks Charles! "Charles Kenyon" wrote: My guess is that the combo boxes and checkboxes you have working are inserted using the Controls Toolbox rather than the forms toolbar. The reason I asked about the number of records is that I use a work-around for working with a single record, but it won't work with 25. Try Doug's solution. -- 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. "Jessica Jones" wrote in message ... I am up for trying anything. I have minor VBA and VB experience. Right now, we have about 25 records that I need to merge. Taking the information out of one program and using excel really only a sa middleware to add some more fields to be able to collect some information. Then, I wanted the online form to save the information as a delimited text file to be able to import into access. I know this is a very long way around, most would say, import it into access directly and use those forms. BUT, the people who will do the data entry are very afraid of access. Thanks for your rapid responses. I really appreciate your time. I knew there had to be a reason my text boxes were misbehaving. Why do the combo boxes and check boxes still work? "Charles Kenyon" wrote: Yes, this is how it works. MailMerge and Online forms are mutually incompatible. If it is protected you can't merge. After you merge, your fields are gone. Part of this, I'm sure, has to do with using bookmarks for form fields. Bookmarks are lost in a mailmerge because they need to be unique. How many records are you merging into your form? -- 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. "Jessica Jones" Jessica wrote in message news I have created an online form that utilizes check boxes, text boxes, and a combo box. The data source is an excel worksheet. After I merge the data into the form, I protect the form. None of my text boxes will accept focus. The check boxes work fine and the combo box works fine. I will appreciate any help. Thank you. |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge with an "online form" problem with text box
The Forms toolbar does not have combo boxes! It has drop downs.
-- 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. "Jessica Jones" wrote in message ... Good Monday Morning! Just to keep the information correct, I wanted to respond to and state that I definitely used the forms toobar and not the Controls toolbox with the checkboxes and combo box. That is really what has me so frustrated. Thanks Charles! "Charles Kenyon" wrote: My guess is that the combo boxes and checkboxes you have working are inserted using the Controls Toolbox rather than the forms toolbar. The reason I asked about the number of records is that I use a work-around for working with a single record, but it won't work with 25. Try Doug's solution. -- 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. "Jessica Jones" wrote in message ... I am up for trying anything. I have minor VBA and VB experience. Right now, we have about 25 records that I need to merge. Taking the information out of one program and using excel really only a sa middleware to add some more fields to be able to collect some information. Then, I wanted the online form to save the information as a delimited text file to be able to import into access. I know this is a very long way around, most would say, import it into access directly and use those forms. BUT, the people who will do the data entry are very afraid of access. Thanks for your rapid responses. I really appreciate your time. I knew there had to be a reason my text boxes were misbehaving. Why do the combo boxes and check boxes still work? "Charles Kenyon" wrote: Yes, this is how it works. MailMerge and Online forms are mutually incompatible. If it is protected you can't merge. After you merge, your fields are gone. Part of this, I'm sure, has to do with using bookmarks for form fields. Bookmarks are lost in a mailmerge because they need to be unique. How many records are you merging into your form? -- 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. "Jessica Jones" Jessica wrote in message news I have created an online form that utilizes check boxes, text boxes, and a combo box. The data source is an excel worksheet. After I merge the data into the form, I protect the form. None of my text boxes will accept focus. The check boxes work fine and the combo box works fine. I will appreciate any help. Thank you. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating dynamic cross reference links in a Word document | Microsoft Word Help | |||
Strange merge problem...? | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge | |||
A problem with text boxes and free space on the page | New Users | |||
textbox to normal text | New Users |