mail merge question

[geotso]

According KB Article 211303 (http://support.microsoft.com/?kbid=211303)
the fields included there produce (in Word 2000) a list like:

Atlanta

Smith $3,000
Gates $50,000
Henderson $10,000

Houston

Jones $8,000
Kelley $9,000
Peterson $0

However, when I try to reproduce the example (in Word 2007), the output is:

Atlanta

Smith $3,000

Gates $50,000

Henderson $10,000


Houston

Jones $8,000

Kelley $9,000

Peterson $0

How can I remove the extra paragraph marks (before the second city and
between the records of each city)?

Thanks

 

[macropod]

Hi geotso,

As far as i can see, the technique you referred to doesn't insert extra paragraphs.

I suspect your paragraph formatting is inserting extra spacing between paragraphs. You can change that via Format|Paragraph or
Format|Style|Paragraph.

Alternatively, you may have accidentally inserted an extra paragraph into your field coding. If you select the field and press
Shift-F9 to can review & edit the code.

 

[geotso]

then, macropod climbed to the rostrum and said:

Hi geotso,

As far as i can see, the technique you referred to doesn't insert extra
paragraphs.

I suspect your paragraph formatting is inserting extra spacing between
paragraphs. You can change that via Format|Paragraph or
Format|Style|Paragraph.

Nope!
I use Normal style with Before/After spacing set to 0, Line spacing
single, and with Don't add space between paragraphs with the same style
checked.

Alternatively, you may have accidentally inserted an extra paragraph
into your field coding. If you select the field and press Shift-F9 to
can review & edit the code.

Nope!
I have Show Paragraph marks button enabled and there are only 6
paragraph marks as in the sample of the article.
FYI the extra paragraphs are produced when the data source file is an
excel table. If I use a text file, with tab separated values, the list I
get is OK (no extra paragraphs).
Is this a known issue?

 

[macropod]

Hi geotso,

Yes, I see what you mean - an extra line is inserted for Excel data sources. Try this (simpler) field coding:
{QUOTE{IF{MERGESEQ}= 1 {SET Place " "}}"{IF{MERGEFIELD City}<> {Place} "<ENTER>
{MERGEFIELD City \* Upper}{SET Place {MERGEFIELD City}}<ENTER>
"}{MERGEFIELD Employee}<TAB>{MERGEFIELD Sales}<ENTER>
"}<ENTER>

 

[macropod]

And here's a slightly more refined version, to suppress the (unwanted) extra para for the 1st record:
{QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City}<> {Place} "{IF{MERGESEQ}= 1 "" "<ENTER>
"}{MERGEFIELD City}{SET Place {MERGEFIELD City}}<ENTER>
<ENTER>
"}{MERGEFIELD Employee}<TAB>{MERGEFIELD Sales}<ENTER>
"}<ENTER>

 

[geotso]

then, macropod climbed to the rostrum and said:

And here's a slightly more refined version, to suppress the (unwanted)
extra para for the 1st record:
{QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City}<> {Place}
"{IF{MERGESEQ}= 1 "" "<ENTER>
"}{MERGEFIELD City}{SET Place {MERGEFIELD City}}<ENTER>
<ENTER>
"}{MERGEFIELD Employee}<TAB>{MERGEFIELD Sales}<ENTER>
"}<ENTER>

gorgeous! Thanks macropod!
I won't forget to mention your nickname in my blog article, and how much
you've helped me!