Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-25-2013, 12:03 AM
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

Thanks for your responses to my questions Paul, but I'm still unclear on how to achieve what I'm trying to do...

Re: the justification question- Do I need to insert braces and then use Word's insert tabs dialog to insert the tab stop and tab? What value would I put in the Tab Stop position? That's what I tried and got partial results but two of the currency fields were pushed further to the right, perhaps because the month abbreviations for 'Mar' and 'May' take up slightly more space than 'Feb'?

Re: inserting a Totals line - I just need totals for one group (Amounts) per key. I inserted
Quote:
{Set Tot1 0 }
immediately after the {Set Key) statement in the first line of code. Then, I output Tot1 just after
Quote:
{IF {MERGESEQ} >1 "
.

Further down, where I output date and amount records, I inserted
Quote:
{Set Tot1 {=Tot1+{MERGEFIELD Amount}}}
, which if I understand correctly is where each amount is being summed into Tot1. However, the Total shows as 0. :{

My understanding of the syntax is still rudimentary and I think I must be missing something. Thanks in advance for any suggestions.
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 02:38 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