Help on Mail Merge just only Show One Record

[Alan Tang]

Hello:

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

Data File:
City Employee Sales Atlanta Galos $3,000 Atlanta Delaney $50,000 Atlanta Henningsen $10,000 Houston Johnson $8,000 Houston Kelly $9,000 Houston Pak $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!

 

[Graham Mayor]

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?

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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!

 

[Alan Tang]

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!