Help on Mail Merge just only Show One Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Tang - 20 Feb 2006 00:47 GMT

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello: 
 
    I have trying to perform the Mail Merge in Word 2003. However, it
just only display by each record. 
 
Data File: 

<table border="1" cellpadding="6" cellspacing="2" width="60%">
<tbody>
<tr>
<th align="left" valign="bottom">City</th>
<th align="left" valign="bottom">Employee</th>
<th align="left" valign="bottom">Sales</th>
</tr>
<tr>
<td valign="top">Atlanta</td>
<td valign="top">Galos</td>
<td valign="top">$3,000</td>
</tr>
<tr>
<td valign="top">Atlanta</td>
<td valign="top">Delaney</td>
<td valign="top">$50,000</td>
</tr>
<tr>
<td valign="top">Atlanta</td>
<td valign="top">Henningsen</td>
<td valign="top">$10,000</td>
</tr>
<tr>
<td valign="top">Houston</td>
<td valign="top">Johnson</td>
<td valign="top">$8,000</td>
</tr>
<tr>
<td valign="top">Houston</td>
<td valign="top">Kelly</td>
<td valign="top">$9,000</td>
</tr>
<tr>
<td valign="top">Houston</td>
<td valign="top">Pak</td>
<td valign="top">$0</td>
</tr>
</tbody>
</table>
 
Field Code: 
{ IF { MERGESEQ } = "1" "{ MERGEFIELD
CITY }¶ 
" "" }{ SET Place1 { MERGEFIELD CITY }}¶ 
{ If { Place2 } <> { Place1 }"¶ 
{ MERGEFIELD CITY }¶ 
¶ 
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{
MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" }{
SET Place2 { MERGEFIELD CITY }}¶ 
 
Expect Result: 
<div class="indent">Atlanta 
 
Galos $3,000 
Delaney $50,000 
Henningsen $10,000 
 
Houston 
 
Johnson $8,000 
Kelly $9,000 
Pak $0 </div>
 
Existing Problem Result: 
<div class="indent">Atlanta 
 
Galos $3,000 
-----------(Next Record) 
Atlanta 
 
Delaney $50,000 
-----------(Next Record) 
Atlanta 
 
Henningsen $10,000 
-----------(Next Record) 
Houston 
 
Johnson $8,000 
-----------(Next Record) 
Houston 
 
Kelly $9,000 
-----------(Next Record) 
Houston 
 
Pak $0 </div>
 
Can you kindly give me some hints? 
 
Thanks a lot! 
</body>
</html>

Reply to this Message

Graham Mayor - 20 Feb 2006 07:49 GMT

It appears you have been messing around with
http://support.microsoft.com/?kbid=294686 ?
Did you miss the bit about setting the document type to directory?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Hello:

I have trying to perform the Mail Merge in Word 2003. However, it just
only display by each record.

Data File:
CityEmployeeSales
AtlantaGalos$3,000
AtlantaDelaney$50,000
AtlantaHenningsen$10,000
HoustonJohnson$8,000
HoustonKelly$9,000
HoustonPak$0

Field Code:
{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶
" "" }{ SET Place1 { MERGEFIELD CITY }}¶
{ If { Place2 } <> { Place1 }"¶
{ MERGEFIELD CITY }¶
¶
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

Expect Result:

Atlanta

Galos $3,000
Delaney $50,000
Henningsen $10,000

Houston

Johnson $8,000
Kelly $9,000
Pak $0

Existing Problem Result:

Atlanta

Galos $3,000
-----------(Next Record)
Atlanta

Delaney $50,000
-----------(Next Record)
Atlanta

Henningsen $10,000
-----------(Next Record)
Houston

Johnson $8,000
-----------(Next Record)
Houston

Kelly $9,000
-----------(Next Record)
Houston

Pak $0

Can you kindly give me some hints?

Thanks a lot!

Reply to this Message

Alan Tang - 21 Feb 2006 10:57 GMT

> It appears you have been messing around with
> http://support.microsoft.com/?kbid=294686 ?
> Did you miss the bit about setting the document type to directory?
>
>

I have re-do and make sure the steps but it just only show one-by-one only!

Reply to this Message