View Single Post
 
Old 10-04-2011, 08:29 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi bh,

I got the Excel wb OK. Try adapting the first field in the 'Force Each New Category To a New Page' topic to look like:
{QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}
"{IF{QUOTE{MERGEFIELD FirstOrganization}{MERGEFIELD Last}}<> {Key} "{IF{MERGESEQ}> 1 {QUOTE 12}}{MERGEFIELD FirstOrganization \f " "}{MERGEFIELD Last}{SET Key {QUOTE{MERGEFIELD FirstOrganization}{MERGEFIELD Last}}
Date Donation
"} {MERGEFIELD Date} {MERGEFIELD Donation_Amount}
"}

That should give you a list like:
Pastor Roy Aiken
Date Donation
1/15/2011 $75.00
……… Page Break ………
Barry Hartmann
Date Donation
2/14/2011 HP LaserJet Pro M1536dnf MFP Multi-function printer Serial #CNB9BC8D30
2/14/2011 HP PSC 2110 All-In-One Printer Serial #MY26PC6391
2/14/2011 HP C6656A Black Ink Cartridge
2/14/2011 HP C6657A Color Ink Cartridge
……… Page Break ………
Sharon Herbster
Date Donation
1/15/2011 $75.00
……… Page Break ………
etc
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Last edited by macropod; 10-04-2011 at 08:45 PM. Reason: Added line breaks to field code representation to make it easier to follow.