#1
|
|||
|
|||
Total of sums in mail merge directory
Hello,
I've been using an excellent tutorial provided by Doug Robbins. Thusfar I have been successful simply replacing my field names with those in the tutorial and shuffling things about to suit my formatting needs. Which, of course, means that I'm not really sure what I'm doing, but I know that it's working. The part of the tutorial that covers calculations on merge data (i.e. generating data that isn't in a field in the spreadsheet) sort of lost me because it involves working with two keys. At this point, I have: {QUOTE{IF{MERGESEQ}=1{SET Key""}{SET LastKey{REF Key}}}"{IF{MERGEFIELD Orgcd}<>{REF Key}"{IF{MERGESEQ}>1"{QUOTE 12}"}{SET Key{MERGEFIELD Orgcd}}"}{MERGEFIELD Title} {MERGEFIELD Paymentamt \# $,0}"} So, for every record with the same Orgcd, a title "Title" and price "Paymentamt" are printed until the next Orgcd comes along, at which point there is a page break. I'm trying to add a total line that will sum up the Paymentamt numbers for any given set of titles. May I ask for a pointer or two for accomplishing this? Thanks! Chris |
#2
|
||||
|
||||
That's something covered in my own Microsoft Word Catalogue/Directory Mailmerge Tutorial, available at:
http://windowssecrets.com/forums/sho...merge-Tutorial or: http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip In particular, see the topic Calculating Group and Sub-Group Totals. Do read the tutorial before trying to use the mailmerge document included with it.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you Paul. I will read that when I get back to the office (lower case "o" ) later today.
Regards, Chris |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Directory Mail Merge | IslandAC | Mail Merge | 1 | 09-09-2016 04:53 PM |
Directory Mail Merge Trouble | Murph14 | Mail Merge | 5 | 06-03-2015 12:22 AM |
table format after mail merge (directory) | laboymc | Mail Merge | 0 | 03-16-2015 07:17 AM |
Directory Mail Merge with table layout | 3N1GM4 | Mail Merge | 11 | 06-03-2014 09:54 PM |
Directory Mail Merge Issues | dbpros_crm | Mail Merge | 10 | 01-20-2014 11:05 PM |