Reply
 
Thread Tools Display Modes
  #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!
  #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!


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

Graham Mayor wrote:
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merging formatted content donna Mailmerge 18 July 28th 06 06:20 PM
How to Mail Merge information to show up in the Label templae? Dnalaw Mailmerge 1 February 16th 06 05:06 AM
protect mail merge record template so others may 'save as' & use John@ParkerCollege Tables 2 February 8th 06 02:05 PM
Mail Merge only displays {{next record}} UggyWuggy Mailmerge 3 December 12th 05 08:44 AM
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM


All times are GMT +1. The time now is 08:06 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"