Mail Merge method to fill Word Text Form Fill Obect Question bosshog 11/4/2008 8:52:01 PM To developers: I have a mail merge question for someone who can assist me. I have an excel '03 file which has about 10 columns of data with about 300 rows. I have a need to move this data using mail merge to a word file to fill unique text form fill objects that are housed into a different format within word '03. I have the F1-F10 match the column data to the word text form fill objects in the order of the word table. The mail merge works. Except instead of filling lines in the word table, mail merge makes 300 tables rather than the 300 rows in the one table. So, what can be done to make mail merge work to map rows in the one table rather than 300 tables? Thank you in advance, Earl Jackson -- ********************** A E Jackson alejack12001[ at ]yahoo.com **********************

Re: Mail Merge method to fill Word Text Form Fill Obect Question "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/4/2008 9:29:24 PM Use a Directory type mail merge 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 "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message news:EC5C15DF-2620-4EAD-9F0D-5E6337050471[ at ]microsoft.com... [Quoted Text] > To developers: > > I have a mail merge question for someone who can assist me. I have an > excel > '03 file which has about 10 columns of data with about 300 rows. I have a > need to move this data using mail merge to a word file to fill unique text > form fill objects that are housed into a different format within word '03. > I > have the F1-F10 match the column data to the word text form fill objects > in > the order of the word table. The mail merge works. Except instead of > filling > lines in the word table, mail merge makes 300 tables rather than the 300 > rows > in the one table. So, what can be done to make mail merge work to map rows > in > the one table rather than 300 tables? > > Thank you in advance, > > Earl Jackson > -- > ********************** > A E Jackson > alejack12001[ at ]yahoo.com > **********************

Re: Mail Merge method to fill Word Text Form Fill Obect Question bosshog 11/8/2008 12:49:00 PM Can you explain or refer me to a link where I can learn as to what is meant by a dictionary mail merge main document. Thank you, Earl Jackson -- ********************** A E Jackson alejack12001[ at ]yahoo.com ********************** "Doug Robbins - Word MVP" wrote: [Quoted Text] > Use a Directory type mail merge 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 > > "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message > news:EC5C15DF-2620-4EAD-9F0D-5E6337050471[ at ]microsoft.com... > > To developers: > > > > I have a mail merge question for someone who can assist me. I have an > > excel > > '03 file which has about 10 columns of data with about 300 rows. I have a > > need to move this data using mail merge to a word file to fill unique text > > form fill objects that are housed into a different format within word '03. > > I > > have the F1-F10 match the column data to the word text form fill objects > > in > > the order of the word table. The mail merge works. Except instead of > > filling > > lines in the word table, mail merge makes 300 tables rather than the 300 > > rows > > in the one table. So, what can be done to make mail merge work to map rows > > in > > the one table rather than 300 tables? > > > > Thank you in advance, > > > > Earl Jackson > > -- > > ********************** > > A E Jackson > > alejack12001[ at ]yahoo.com > > ********************** > > >

Re: Mail Merge method to fill Word Text Form Fill Obect Question "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 11/8/2008 1:26:43 PM It is 'directory' not 'dictionary'. A directory merge puts one record immediately after the one before it, as opposed to a letter merge which starts each record on a new page. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> bosshog wrote: [Quoted Text] > Can you explain or refer me to a link where I can learn as to what is > meant by a dictionary mail merge main document. > > Thank you, > > Earl Jackson > >> Use a Directory type mail merge 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 >> >> "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message >> news:EC5C15DF-2620-4EAD-9F0D-5E6337050471[ at ]microsoft.com... >>> To developers: >>> >>> I have a mail merge question for someone who can assist me. I have >>> an excel >>> '03 file which has about 10 columns of data with about 300 rows. I >>> have a need to move this data using mail merge to a word file to >>> fill unique text form fill objects that are housed into a different >>> format within word '03. I >>> have the F1-F10 match the column data to the word text form fill >>> objects in >>> the order of the word table. The mail merge works. Except instead of >>> filling >>> lines in the word table, mail merge makes 300 tables rather than >>> the 300 rows >>> in the one table. So, what can be done to make mail merge work to >>> map rows in >>> the one table rather than 300 tables? >>> >>> Thank you in advance, >>> >>> Earl Jackson >>> -- >>> ********************** >>> A E Jackson >>> alejack12001[ at ]yahoo.com >>> **********************

Re: Mail Merge method to fill Word Text Form Fill Obect Question bosshog 11/9/2008 1:00:01 PM Sorry, I miss read. You have a very concise website. Thank you, I will look into directory mail merger. Earl Jackson -- ********************** A E Jackson alejack12001[ at ]yahoo.com ********************** "Graham Mayor" wrote: [Quoted Text] > It is 'directory' not 'dictionary'. A directory merge puts one record > immediately after the one before it, as opposed to a letter merge which > starts each record on a new page. > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > bosshog wrote: > > Can you explain or refer me to a link where I can learn as to what is > > meant by a dictionary mail merge main document. > > > > Thank you, > > > > Earl Jackson > > > >> Use a Directory type mail merge 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 > >> > >> "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message > >> news:EC5C15DF-2620-4EAD-9F0D-5E6337050471[ at ]microsoft.com... > >>> To developers: > >>> > >>> I have a mail merge question for someone who can assist me. I have > >>> an excel > >>> '03 file which has about 10 columns of data with about 300 rows. I > >>> have a need to move this data using mail merge to a word file to > >>> fill unique text form fill objects that are housed into a different > >>> format within word '03. I > >>> have the F1-F10 match the column data to the word text form fill > >>> objects in > >>> the order of the word table. The mail merge works. Except instead of > >>> filling > >>> lines in the word table, mail merge makes 300 tables rather than > >>> the 300 rows > >>> in the one table. So, what can be done to make mail merge work to > >>> map rows in > >>> the one table rather than 300 tables? > >>> > >>> Thank you in advance, > >>> > >>> Earl Jackson > >>> -- > >>> ********************** > >>> A E Jackson > >>> alejack12001[ at ]yahoo.com > >>> ********************** > > >

Re: Mail Merge method to fill Word Text Form Fill Obect Question bosshog 12/2/2008 3:29:04 AM I tried the directory mail merge and it works great for filling a table. However, I still have a problem. I need to get the data that is in the table into a Text Fill Form Object. Can you suggest how this can be accomplished either from mail merge or macro script? Thank you again, Earl -- ********************** A E Jackson alejack12001[ at ]yahoo.com ********************** "Doug Robbins - Word MVP" wrote: [Quoted Text] > Use a Directory type mail merge 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 > > "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message > news:EC5C15DF-2620-4EAD-9F0D-5E6337050471[ at ]microsoft.com... > > To developers: > > > > I have a mail merge question for someone who can assist me. I have an > > excel > > '03 file which has about 10 columns of data with about 300 rows. I have a > > need to move this data using mail merge to a word file to fill unique text > > form fill objects that are housed into a different format within word '03. > > I > > have the F1-F10 match the column data to the word text form fill objects > > in > > the order of the word table. The mail merge works. Except instead of > > filling > > lines in the word table, mail merge makes 300 tables rather than the 300 > > rows > > in the one table. So, what can be done to make mail merge work to map rows > > in > > the one table rather than 300 tables? > > > > Thank you in advance, > > > > Earl Jackson > > -- > > ********************** > > A E Jackson > > alejack12001[ at ]yahoo.com > > ********************** > > >

Re: Mail Merge method to fill Word Text Form Fill Obect Question "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/2/2008 6:36:41 AM What exactly do you mean by a Text Fill Form Object? -- 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 "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message news:67BF7C96-8E61-4BD3-917E-5995CB08DF96[ at ]microsoft.com... [Quoted Text] >I tried the directory mail merge and it works great for filling a table. > However, I still have a problem. I need to get the data that is in the > table > into a Text Fill Form Object. Can you suggest how this can be accomplished > either from mail merge or macro script? > > Thank you again, > > Earl > -- > ********************** > A E Jackson > alejack12001[ at ]yahoo.com > ********************** > > > "Doug Robbins - Word MVP" wrote: > >> Use a Directory type mail merge 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 >> >> "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message >> news:EC5C15DF-2620-4EAD-9F0D-5E6337050471[ at ]microsoft.com... >> > To developers: >> > >> > I have a mail merge question for someone who can assist me. I have an >> > excel >> > '03 file which has about 10 columns of data with about 300 rows. I have >> > a >> > need to move this data using mail merge to a word file to fill unique >> > text >> > form fill objects that are housed into a different format within word >> > '03. >> > I >> > have the F1-F10 match the column data to the word text form fill >> > objects >> > in >> > the order of the word table. The mail merge works. Except instead of >> > filling >> > lines in the word table, mail merge makes 300 tables rather than the >> > 300 >> > rows >> > in the one table. So, what can be done to make mail merge work to map >> > rows >> > in >> > the one table rather than 300 tables? >> > >> > Thank you in advance, >> > >> > Earl Jackson >> > -- >> > ********************** >> > A E Jackson >> > alejack12001[ at ]yahoo.com >> > ********************** >> >> >>

Re: Mail Merge method to fill Word Text Form Fill Obect Question bosshog 12/2/2008 12:46:00 PM Thank you for responding. The Text Form Fill Object is I believe a GUI object that is embedded into a word document to gather data for a database of some sort like Access. The Text Form Fill Object houses a field for entering text and other fields such as the font, size, a link to the parent document. I haven't found much from Microsoft on the subject to explain further. The document that I am using has several of these Text Form Fill Objects in it. So far, I have to enter that data by hand into the text field. If there is a way to enter that tabled data in to the object by use of macro or some other means then I am open to try it since I have a large volume of data to enter. Thank you, again, Earl -- ********************** A E Jackson alejack12001[ at ]yahoo.com ********************** "Doug Robbins - Word MVP" wrote: [Quoted Text] > What exactly do you mean by a Text Fill Form Object? > > -- > 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 > > "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message > news:67BF7C96-8E61-4BD3-917E-5995CB08DF96[ at ]microsoft.com... > >I tried the directory mail merge and it works great for filling a table. > > However, I still have a problem. I need to get the data that is in the > > table > > into a Text Fill Form Object. Can you suggest how this can be accomplished > > either from mail merge or macro script? > > > > Thank you again, > > > > Earl > > -- > > ********************** > > A E Jackson > > alejack12001[ at ]yahoo.com > > ********************** > > > > > > "Doug Robbins - Word MVP" wrote: > > > >> Use a Directory type mail merge 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 > >> > >> "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message > >> news:EC5C15DF-2620-4EAD-9F0D-5E6337050471[ at ]microsoft.com... > >> > To developers: > >> > > >> > I have a mail merge question for someone who can assist me. I have an > >> > excel > >> > '03 file which has about 10 columns of data with about 300 rows. I have > >> > a > >> > need to move this data using mail merge to a word file to fill unique > >> > text > >> > form fill objects that are housed into a different format within word > >> > '03. > >> > I > >> > have the F1-F10 match the column data to the word text form fill > >> > objects > >> > in > >> > the order of the word table. The mail merge works. Except instead of > >> > filling > >> > lines in the word table, mail merge makes 300 tables rather than the > >> > 300 > >> > rows > >> > in the one table. So, what can be done to make mail merge work to map > >> > rows > >> > in > >> > the one table rather than 300 tables? > >> > > >> > Thank you in advance, > >> > > >> > Earl Jackson > >> > -- > >> > ********************** > >> > A E Jackson > >> > alejack12001[ at ]yahoo.com > >> > ********************** > >> > >> > >> > > >

Re: Mail Merge method to fill Word Text Form Fill Obect Question "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/3/2008 2:25:14 AM What version of Word are you using. By Text Form Fill Object do you mean a FormField as is using in a document that is Protected for Forms. As far as I know, there is no object in Word that has the name "Text Form Fill" -- 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 "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message news:3EB54D90-B682-4DA1-9279-51D0DF1FCF5D[ at ]microsoft.com... [Quoted Text] > Thank you for responding. The Text Form Fill Object is I believe a GUI > object > that is embedded into a word document to gather data for a database of > some > sort like Access. The Text Form Fill Object houses a field for entering > text > and other fields such as the font, size, a link to the parent document. I > haven't found much from Microsoft on the subject to explain further. The > document that I am using has several of these Text Form Fill Objects in > it. > So far, I have to enter that data by hand into the text field. If there is > a > way to enter that tabled data in to the object by use of macro or some > other > means then I am open to try it since I have a large volume of data to > enter. > > Thank you, again, > > Earl > -- > ********************** > A E Jackson > alejack12001[ at ]yahoo.com > ********************** > > > "Doug Robbins - Word MVP" wrote: > >> What exactly do you mean by a Text Fill Form Object? >> >> -- >> 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 >> >> "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message >> news:67BF7C96-8E61-4BD3-917E-5995CB08DF96[ at ]microsoft.com... >> >I tried the directory mail merge and it works great for filling a table. >> > However, I still have a problem. I need to get the data that is in the >> > table >> > into a Text Fill Form Object. Can you suggest how this can be >> > accomplished >> > either from mail merge or macro script? >> > >> > Thank you again, >> > >> > Earl >> > -- >> > ********************** >> > A E Jackson >> > alejack12001[ at ]yahoo.com >> > ********************** >> > >> > >> > "Doug Robbins - Word MVP" wrote: >> > >> >> Use a Directory type mail merge 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 >> >> >> >> "bosshog" <bosshog[ at ]discussions.microsoft.com> wrote in message >> >> news:EC5C15DF-2620-4EAD-9F0D-5E6337050471[ at ]microsoft.com... >> >> > To developers: >> >> > >> >> > I have a mail merge question for someone who can assist me. I have >> >> > an >> >> > excel >> >> > '03 file which has about 10 columns of data with about 300 rows. I >> >> > have >> >> > a >> >> > need to move this data using mail merge to a word file to fill >> >> > unique >> >> > text >> >> > form fill objects that are housed into a different format within >> >> > word >> >> > '03. >> >> > I >> >> > have the F1-F10 match the column data to the word text form fill >> >> > objects >> >> > in >> >> > the order of the word table. The mail merge works. Except instead of >> >> > filling >> >> > lines in the word table, mail merge makes 300 tables rather than the >> >> > 300 >> >> > rows >> >> > in the one table. So, what can be done to make mail merge work to >> >> > map >> >> > rows >> >> > in >> >> > the one table rather than 300 tables? >> >> > >> >> > Thank you in advance, >> >> > >> >> > Earl Jackson >> >> > -- >> >> > ********************** >> >> > A E Jackson >> >> > alejack12001[ at ]yahoo.com >> >> > ********************** >> >> >> >> >> >> >> >> >>