View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Greg
 
Posts: n/a
Default Multiple sub-entries for one main entry

Doug,

Cracked it!!! Thanks for the nudge.

I adpated the Q211303 method as follows to meet my needs:

{ SET Name1 { MF Name }}{ IF { MERGESEQ } = "1""{ IF { Name1 } =
"""enter
{ MF Donations }"enter
"Name: { MF Name } Address: { MF Address }enter
enter
{ MF Donations }"} ""{ IF { Name1 } = """enter
{ MF Donations }"enter
"enter
Page Break
Name: { MF Name } Address: { MF Address }enter
enter
{ MF Donations }"} " }enter

MF stands in for the full text MERGEFIELD in the actual field code.

This works for an EXCEL spreadsheet laid out as:

Name Address Donations
Bill Miller 123 Cherry St. $60.00
$40.00
$25.00
Mary Poppins 456 Pine St. $100.00
$50.00
Tom Sawyer ....

where the blank spaces are empter mergefields.

Thanks again.