#1
|
|||
|
|||
SUM a single mergefield
Hello All, this is my first time to the forums and I am also fairly new to mail merge. So first off thanks for any help!
I am running mail merge to create a Quote from Microsoft Dynamics CRM 2011. In the Quote there are a series of products each one is different and ranges in the number of products that might be requested. The merge field for example might be {Mergefield Quote_Product_Cost} and the output would list all the product costs for each product requested. If possible I would like to be able to add up all the product costs. I have tried {=SUM({Mergefield Quote_Product_cost})} but I get a syntax error. Could someone please tell me what I'm doing wrong or if this is even possible? So far the only thing I have seen is how to sum up two different mail merge fields but in my case the one mergefield returns several values. Thanks so much for the help. |
#2
|
||||
|
||||
You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. For some worked examples, see the attachments to the posts at: https://www.msofficeforums.com/mail-...html#post23345 https://www.msofficeforums.com/mail-...html#post30327 Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from: Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or Doug Robbins at https://skydrive.live.com/?cid=5aedc...615E886B%21566
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problems With MergeField Switches | JennEx | Mail Merge | 56 | 04-28-2013 06:40 PM |
Substituting a value using MERGEFIELD | CharlieVW | Mail Merge | 3 | 05-07-2012 12:11 PM |
Word vs Excel (NEXTIF, SKIPIF mergefield) | jerry00769 | Mail Merge | 3 | 04-30-2012 03:43 PM |
Mergefield IF/ELSE determin source type | legg1 | Mail Merge | 6 | 03-26-2012 09:18 PM |
Mergefield date error | michielvanderbiest | Mail Merge | 1 | 04-12-2010 11:22 PM |