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

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

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


"Alan Tang" wrote in message
...
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!