View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Alan Tang
 
Posts: n/a
Default Help on Mail Merge just only Show One Record

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!