Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2013, 02:55 PM
kawirider88 kawirider88 is offline SUM a single mergefield Windows 7 64bit SUM a single mergefield Office 2010 32bit
Novice
SUM a single mergefield
 
Join Date: Jun 2013
Posts: 2
kawirider88 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 09-29-2013, 06:37 PM
macropod's Avatar
macropod macropod is offline SUM a single mergefield Windows 7 32bit SUM a single mergefield Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUM a single mergefield Problems With MergeField Switches JennEx Mail Merge 56 04-28-2013 06:40 PM
SUM a single mergefield Substituting a value using MERGEFIELD CharlieVW Mail Merge 3 05-07-2012 12:11 PM
SUM a single mergefield Word vs Excel (NEXTIF, SKIPIF mergefield) jerry00769 Mail Merge 3 04-30-2012 03:43 PM
SUM a single mergefield 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:46 PM.


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