Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-23-2013, 07:59 PM
hadenp hadenp is offline Right Justify Values in a Mail Merge Windows XP Right Justify Values in a Mail Merge Office 2010 32bit
Novice
Right Justify Values in a Mail Merge
 
Join Date: Dec 2013
Posts: 4
hadenp is on a distinguished road
Default Right Justify Values in a Mail Merge

I'm working up a Word mail merge "Thank you" letter for a non-profit that lists the dates and amounts given for each donor during the year for tax deduction purposes.

For this, I've relied heavily on the Word Catalogue Mailmerge tutorial and after great difficulty understanding it, I'm now beginning to 'get it'. Thank you Paul!

So, now I can list the values, but how do I format them to look 'good' on the page? For me, that means right justifying the $ amounts under the "Amount" heading. Is that best done with tabs? How do I specify that within the field code syntax that I'm using to generate the list? Also, how to underline the heading text? The output would ideally look something like this - only better.



Date………......Amount
Feb/01/2013 $225.00
Mar/01/2013 $10.00
Apr/01/2013 $50.00
------------------------------
Total $285.00

Finally, I'd like to have Total line at the bottom with a sum of the amounts. Is that best calculated as a formula the Excel spreadsheet? How would I underline the last amount

Thanks again for the tutorial.
Reply With Quote
 

Tags
field code, justification, tabs



Similar Threads
Thread Thread Starter Forum Replies Last Post
Loss of formulae values when mail merging excel to word MellowMel Mail Merge 6 05-09-2014 09:08 AM
Prevent Zero Values being Suppressed in a Mail Merge HangMan Mail Merge 2 12-11-2013 02:28 PM
Right Justify Values in a Mail Merge Content control merge values? skrallemand Word VBA 8 10-02-2013 06:54 AM
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Right Justify Values in a Mail Merge Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:49 AM.


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