[ibmm]

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.

[macropod[_2_]]

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.

[Doug Robbins - Word MVP]

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.

[ibmm]

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.

.

[Doug Robbins - Word MVP]

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.

.

[macropod[_2_]]

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.

.

[macropod[_2_]]

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.

.

[Doug Robbins - Word MVP]

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.

.

[macropod[_2_]]

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.

.

[Doug Robbins - Word MVP]

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.

.

[ibmm]

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.

.

.

[macropod[_2_]]

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.

.

.