Re: Mail Merge Combine Records To Table
- From: "macropod" <macropod@xxxxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2009 13:56:12 +1100
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" <KevinL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0D61E395-5ED6-41FF-A5B1-CC8D1031A962@xxxxxxxxxxxxxxxx
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" <KevinL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:533D4C0F-C95F-4A20-BE73-B86121EE4991@xxxxxxxxxxxxxxxx
>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.aspx/kb/294686/en-us
>
> MVP macropod's tutorial
> http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107
>
> Cornell Training Article
> http://cornell.veplan.net/article.aspx?&a=3815
.
- Follow-Ups:
- Re: Mail Merge Combine Records To Table
- From: macropod
- Re: Mail Merge Combine Records To Table
- References:
- Mail Merge Combine Records To Table
- From: KevinL
- Re: Mail Merge Combine Records To Table
- From: Doug Robbins - Word MVP on news.microsoft.com
- Re: Mail Merge Combine Records To Table
- From: KevinL
- Mail Merge Combine Records To Table
- Prev by Date: Re: Mail Merge Combine Records To Table
- Next by Date: Re: Mail Merge Combine Records To Table
- Previous by thread: Re: Mail Merge Combine Records To Table
- Next by thread: Re: Mail Merge Combine Records To Table
- Index(es):
Relevant Pages
|
