Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #17  
Old 10-05-2011, 07:17 PM
macropod's Avatar
macropod macropod is offline Mail merge with Duplicate Names but Different Dollar Amounts Windows 7 64bit Mail merge with Duplicate Names but Different Dollar Amounts Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,516
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,

That field coding is taken from the first example under the tutorial's heading 'Using a Dummy Last Record to Generate the Trailing Text Per Group'. As explained there, you need to create a dummy record with just a 0 in the relevant field (in this case, the 'FirstOrganisation' field). You'll see that I did that with the sample workbook attached to my post.

As for the cheque/check #, you can simply add a field coded as:
{IF{MERGEFIELD "check_"}> 0 "(Check #: {MERGEFIELD "check_"})"}
(along with whatever spacing you need) between the fields {MERGEFIELD Date} and {MERGEFIELD "Donation_Amount"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge with Duplicate Names but Different Dollar Amounts Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Mail merge with Duplicate Names but Different Dollar Amounts Mail merge with names in content richard82 Mail Merge 1 07-07-2011 11:28 PM
Mail merge with Duplicate Names but Different Dollar Amounts Selecting Names in New Mail Message jackdashack Outlook 2 06-04-2011 04:19 PM
Duplicate Mail wekhine Outlook 0 06-03-2010 09:08 PM
Convert Dollar amount to text GeorgeLawshe Word 0 03-07-2010 10:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft