Mail Merge Combine Records To Table

I have a need to create a Word Document from Excel. My Excel spreadheet has
multiple rows. Each row has the person's name (just 1 name in the entire
spreadsheet) and the material they may be exposed to, and the exposure level
(multiple materials, 1 on each row).

I would like to put the material and exposure level in a Table in Word. I
have progressed to where I am able to show the name just once and each
material on a separate line on the same page, but it would look cleaner if I
could put these elements in a Table.

I have reviewed each of these links below, all are helpful but none show how
to put the rows into a Table.

Thanks to anyone who is able to advise me whether this is possible or not.

Microsoft
http://support.microsoft.com/default...b/294686/en-us

MVP macropod's tutorial
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

Cornell Training Article
http://cornell.veplan.net/article.aspx?&a=3815

Without seeing the actual arrangement of fields that you have come up with,
it is hard to advise you how to go about this. It may be however that you
will need to convert the relevant text to a table after executing the merge.
While that can probably be done with the use of a macro, more would need to
be known about what the merge produces to provide the code that would be
required.

--
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

"KevinL" wrote in message
...
I have a need to create a Word Document from Excel. My Excel spreadheet
has
multiple rows. Each row has the person's name (just 1 name in the entire
spreadsheet) and the material they may be exposed to, and the exposure
level
(multiple materials, 1 on each row).

I would like to put the material and exposure level in a Table in Word. I
have progressed to where I am able to show the name just once and each
material on a separate line on the same page, but it would look cleaner if
I
could put these elements in a Table.

I have reviewed each of these links below, all are helpful but none show
how
to put the rows into a Table.

Thanks to anyone who is able to advise me whether this is possible or not.

Microsoft
http://support.microsoft.com/default...b/294686/en-us

MVP macropod's tutorial
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

Cornell Training Article
http://cornell.veplan.net/article.aspx?&a=3815

For simplicity's sake, let's say I have 3 fields in my spreadsheet: City,
Employee, and Sales (just like the Microsoft example).

I want my City to be printed once in the document, and then I want a
2-column table with Employee and Sales. There would be a column heading plus
a row in the column for each row in the spreadsheet (for the matching city).

"Doug Robbins - Word MVP on news.microsof" wrote:

Without seeing the actual arrangement of fields that you have come up with,
it is hard to advise you how to go about this. It may be however that you
will need to convert the relevant text to a table after executing the merge.
While that can probably be done with the use of a macro, more would need to
be known about what the merge produces to provide the code that would be
required.

--
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

"KevinL" wrote in message
...
I have a need to create a Word Document from Excel. My Excel spreadheet
has
multiple rows. Each row has the person's name (just 1 name in the entire
spreadsheet) and the material they may be exposed to, and the exposure
level
(multiple materials, 1 on each row).

I would like to put the material and exposure level in a Table in Word. I
have progressed to where I am able to show the name just once and each
material on a separate line on the same page, but it would look cleaner if
I
could put these elements in a Table.

I have reviewed each of these links below, all are helpful but none show
how
to put the rows into a Table.

Thanks to anyone who is able to advise me whether this is possible or not.

Microsoft
http://support.microsoft.com/default...b/294686/en-us

MVP macropod's tutorial
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

Cornell Training Article
http://cornell.veplan.net/article.aspx?&a=3815

Insert a Tab space between the mergefields for the Employee and the Sales in
the mail merge main document then after executing the merge, select those
paragaphs containing the data and use Convert to Table from the Tables menu.

--
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

"KevinL" wrote in message
...
For simplicity's sake, let's say I have 3 fields in my spreadsheet: City,
Employee, and Sales (just like the Microsoft example).

I want my City to be printed once in the document, and then I want a
2-column table with Employee and Sales. There would be a column heading
plus
a row in the column for each row in the spreadsheet (for the matching
city).

"Doug Robbins - Word MVP on news.microsof" wrote:

Without seeing the actual arrangement of fields that you have come up
with,
it is hard to advise you how to go about this. It may be however that
you
will need to convert the relevant text to a table after executing the
merge.
While that can probably be done with the use of a macro, more would need
to
be known about what the merge produces to provide the code that would be
required.

--
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

"KevinL" wrote in message
...
I have a need to create a Word Document from Excel. My Excel spreadheet
has
multiple rows. Each row has the person's name (just 1 name in the
entire
spreadsheet) and the material they may be exposed to, and the exposure
level
(multiple materials, 1 on each row).

I would like to put the material and exposure level in a Table in Word.
I
have progressed to where I am able to show the name just once and each
material on a separate line on the same page, but it would look cleaner
if
I
could put these elements in a Table.

I have reviewed each of these links below, all are helpful but none
show
how
to put the rows into a Table.

Thanks to anyone who is able to advise me whether this is possible or
not.

Microsoft
http://support.microsoft.com/default...b/294686/en-us

MVP macropod's tutorial
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

Cornell Training Article
http://cornell.veplan.net/article.aspx?&a=3815

Hi Kevin,

If you use the field coding from my tutorial, you could insert a single-row table containing the mergefields in it, in place of the
'{ MERGEFIELD City } { MERGEFIELD Representative } { MERGEFIELD Sales }' sequence. Then, when you've completed the merge, run a
macro like the following over the output document:

Sub MailMergeTableJoiner()
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 Len(.Text) = 1 Then .Delete
End If
End With
End If
End With
Next
End Sub

--
Cheers
macropod
[MVP - Microsoft Word]


"KevinL" wrote in message ...
For simplicity's sake, let's say I have 3 fields in my spreadsheet: City,
Employee, and Sales (just like the Microsoft example).

I want my City to be printed once in the document, and then I want a
2-column table with Employee and Sales. There would be a column heading plus
a row in the column for each row in the spreadsheet (for the matching city).

"Doug Robbins - Word MVP on news.microsof" wrote:

Without seeing the actual arrangement of fields that you have come up with,
it is hard to advise you how to go about this. It may be however that you
will need to convert the relevant text to a table after executing the merge.
While that can probably be done with the use of a macro, more would need to
be known about what the merge produces to provide the code that would be
required.

--
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

"KevinL" wrote in message
...
I have a need to create a Word Document from Excel. My Excel spreadheet
has
multiple rows. Each row has the person's name (just 1 name in the entire
spreadsheet) and the material they may be exposed to, and the exposure
level
(multiple materials, 1 on each row).

I would like to put the material and exposure level in a Table in Word. I
have progressed to where I am able to show the name just once and each
material on a separate line on the same page, but it would look cleaner if
I
could put these elements in a Table.

I have reviewed each of these links below, all are helpful but none show
how
to put the rows into a Table.

Thanks to anyone who is able to advise me whether this is possible or not.

Microsoft
http://support.microsoft.com/default...b/294686/en-us

MVP macropod's tutorial
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

Cornell Training Article
http://cornell.veplan.net/article.aspx?&a=3815

Hi Kevin,

I've just added an example to my tutorial, showing how to do a catalog/directory merge to a table (with a slightly different version
of the macro)

--
Cheers
macropod
[MVP - Microsoft Word]


"macropod" wrote in message ...
Hi Kevin,

If you use the field coding from my tutorial, you could insert a single-row table containing the mergefields in it, in place of
the '{ MERGEFIELD City } { MERGEFIELD Representative } { MERGEFIELD Sales }' sequence. Then, when you've completed the merge, run
a macro like the following over the output document:

Sub MailMergeTableJoiner()
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 Len(.Text) = 1 Then .Delete
End If
End With
End If
End With
Next
End Sub

--
Cheers
macropod
[MVP - Microsoft Word]


"KevinL" wrote in message ...
For simplicity's sake, let's say I have 3 fields in my spreadsheet: City,
Employee, and Sales (just like the Microsoft example).

I want my City to be printed once in the document, and then I want a
2-column table with Employee and Sales. There would be a column heading plus
a row in the column for each row in the spreadsheet (for the matching city).

"Doug Robbins - Word MVP on news.microsof" wrote:

Without seeing the actual arrangement of fields that you have come up with,
it is hard to advise you how to go about this. It may be however that you
will need to convert the relevant text to a table after executing the merge.
While that can probably be done with the use of a macro, more would need to
be known about what the merge produces to provide the code that would be
required.

--
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

"KevinL" wrote in message
...
I have a need to create a Word Document from Excel. My Excel spreadheet
has
multiple rows. Each row has the person's name (just 1 name in the entire
spreadsheet) and the material they may be exposed to, and the exposure
level
(multiple materials, 1 on each row).

I would like to put the material and exposure level in a Table in Word. I
have progressed to where I am able to show the name just once and each
material on a separate line on the same page, but it would look cleaner if
I
could put these elements in a Table.

I have reviewed each of these links below, all are helpful but none show
how
to put the rows into a Table.

Thanks to anyone who is able to advise me whether this is possible or not.

Microsoft
http://support.microsoft.com/default...b/294686/en-us

MVP macropod's tutorial
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

Cornell Training Article
http://cornell.veplan.net/article.aspx?&a=3815