![]() |
|
|
|
#1
|
|||
|
|||
|
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:
Quote:
Further down, where I output date and amount records, I inserted Quote:
My understanding of the syntax is still rudimentary and I think I must be missing something. Thanks in advance for any suggestions. |
|
#2
|
||||
|
||||
|
Quote:
Quote:
{IF{MERGESEQ}= 1 "{SET Key ""}{SET Tot1 0}" {SET LastKey {REF Key}}} In the attachment, which is based directly on the tutorial, I've implemented the totals for a merge using a single key - using 'Total' instead of 'Tot1'. If you simply connect it to your copy of the tutorial's datasource file, you should be able to generate the merge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#3
|
|||
|
|||
|
I wasn't able to make my document give me totals correctly (kept getting a calculation error that would continue through my (small) recordset) - so I started again with your attachment and gradually introduced my own field names and structure and that worked like a charm. Thanks!
But, I don't have much confidence that I can make changes w/o 'breaking' it. For example, what determines when one needs to wrap code with double quotes? Is there any documentation you could refer me to so I can understand the syntax better? I assume that the opening and closing braces have to be paired, but with nesting it quickly becomes difficult to tell if you're missing a brace. Any thoughts? Thanks again for your help. |
|
| 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 |
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 |
Conditional merge fields in mail merge
|
Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |