Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi there,
I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi ibmm,
To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
See the following page of fellow MVP Graham Mayors website:
http://www.gmayor.com/ManyToOne.htm -- 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, originally posted via msnews.microsoft.com "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Thanks for the sites. I managed to follow the tutorial from
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Try the method at http://www.gmayor.com/ManyToOne.htm
-- 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, originally posted via msnews.microsoft.com "ibmm" wrote in message ... Thanks for the sites. I managed to follow the tutorial from http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi ibmm,
For instructions on how to install & run a macro, see: http://www.gmayor.com/installing_macro.htm -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Thanks for the sites. I managed to follow the tutorial from http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi Doug,
But that still doesn't generate a table for the OP ... -- Cheers macropod [Microsoft MVP - Word] "Doug Robbins - Word MVP" wrote in message ... Try the method at http://www.gmayor.com/ManyToOne.htm -- 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, originally posted via msnews.microsoft.com "ibmm" wrote in message ... Thanks for the sites. I managed to follow the tutorial from http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi Paul,
It can present the data in tabular form. -- 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, originally posted via msnews.microsoft.com "macropod" wrote in message ... Hi Doug, But that still doesn't generate a table for the OP ... -- Cheers macropod [Microsoft MVP - Word] "Doug Robbins - Word MVP" wrote in message ... Try the method at http://www.gmayor.com/ManyToOne.htm -- 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, originally posted via msnews.microsoft.com "ibmm" wrote in message ... Thanks for the sites. I managed to follow the tutorial from http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi Doug,
It can present the data in tabular form. Yes, but as far as I can see, it doesn't actually create a table, or am I missing something? -- Cheers macropod [Microsoft MVP - Word] "Doug Robbins - Word MVP" wrote in message ... Hi Paul, It can present the data in tabular form. -- 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, originally posted via msnews.microsoft.com "macropod" wrote in message ... Hi Doug, But that still doesn't generate a table for the OP ... -- Cheers macropod [Microsoft MVP - Word] "Doug Robbins - Word MVP" wrote in message ... Try the method at http://www.gmayor.com/ManyToOne.htm -- 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, originally posted via msnews.microsoft.com "ibmm" wrote in message ... Thanks for the sites. I managed to follow the tutorial from http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi Paul,
Right, with the code as it now stands, it does not create a row of a table for each "child" record and all of the child records would be in one row of the table if the child mergefields were inserted into the row of a table. As long as the data in each field of the child records is not so long as to cause a word wrap in any of the columns, and if the user did not specifically want a border between each row of data, the result would be pretty much indistinguishable from a multi-row table. With knowledge of the table layout that was required, it would be simple to modify the code so that a new row was added to a table to contain the data for each of the "child" records. -- 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, originally posted via msnews.microsoft.com "macropod" wrote in message ... Hi Doug, It can present the data in tabular form. Yes, but as far as I can see, it doesn't actually create a table, or am I missing something? -- Cheers macropod [Microsoft MVP - Word] "Doug Robbins - Word MVP" wrote in message ... Hi Paul, It can present the data in tabular form. -- 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, originally posted via msnews.microsoft.com "macropod" wrote in message ... Hi Doug, But that still doesn't generate a table for the OP ... -- Cheers macropod [Microsoft MVP - Word] "Doug Robbins - Word MVP" wrote in message ... Try the method at http://www.gmayor.com/ManyToOne.htm -- 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, originally posted via msnews.microsoft.com "ibmm" wrote in message ... Thanks for the sites. I managed to follow the tutorial from http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi there,
I have the macro installed but when I am in the merged document and run the macro I don't see any change in my document. I still get individual tables versus the look of one table. It's like nothing is happening at all. Thanks in advance "macropod" wrote: Hi ibmm, For instructions on how to install & run a macro, see: http://www.gmayor.com/installing_macro.htm -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Thanks for the sites. I managed to follow the tutorial from http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . . |
#12
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to fill a word table with merge fields.
Hi ibmm,
Are you sure the merged document is the active one when you run the macro? -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message news Hi there, I have the macro installed but when I am in the merged document and run the macro I don't see any change in my document. I still get individual tables versus the look of one table. It's like nothing is happening at all. Thanks in advance "macropod" wrote: Hi ibmm, For instructions on how to install & run a macro, see: http://www.gmayor.com/installing_macro.htm -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Thanks for the sites. I managed to follow the tutorial from http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip but their is a macro that it says to run to join the tables together and I have no idea how to run this. It says to run it on the merged document so i go to the merged document, select the macro and select run but it doesn't do anything. So I get a series of single tables... which is close but it would look better if they were joined. Am I suppose to highlight each separate group of tables or is there some trick to it. I am using word 2003. The table joiner macro looks like this. Sub TableJoiner() Dim oPara As Paragraph For Each oPara In ActiveDocument.Paragraphs With oPara.Range If .Information(wdWithInTable) = True Then With .Next If .Information(wdWithInTable) = False Then If .Text = vbCr Then .Delete End If End With End If End With Next End Sub Thank you for your help. I would never in a million years have guessed how to do this. "macropod" wrote: Hi ibmm, To see how to create a table with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://lounge.windowssecrets.com/ind...owtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "ibmm" wrote in message ... Hi there, I'd like to create a mail merge for each instructor in an excel list and show all the courses and dates they are teaching inside a table. I've managed to create a mail merge with a 'directory' so I can get the list of the courses and dates but of course they aren't formatted so it doesn't look good. I would like to put these into a table. I've tried to create a table and put the merge fields in it but then I only get one record per instructor and I don't know what happens to the other records. Is there some trick to this? Thanks in advance. . . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge method to fill Word Text Form Fill Obect Question | Mailmerge | |||
Fillable fields that automatically fill out other fields | Microsoft Word Help | |||
Auto fill Form Fields from previous Variable fields? | Microsoft Word Help | |||
merge from one word doc to another to fill in fields | Mailmerge | |||
Format problem with merge fields in word table | Mailmerge |