Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
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,467
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]
Closed Thread



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 03:31 AM.


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