Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-31-2016, 12:32 PM
ayupchap ayupchap is offline Mac OS X Office 2013
Novice
 
Join Date: Oct 2016
Posts: 6
ayupchap is on a distinguished road
Default Help with a formula. I'm not sure its even possible in Word

Hi there

This is my first post here. I uses forums for MS Access and Salesforce a lot but word I use to a certain level but this is far higher than my ability range. I'm not even sure its possible.

I need to create a formula which subtracts one mail-merge tag from another. Please if you know how I could possibly do this I would be most grateful. I use OSX but have access to a PC with Office professional also.

I have attached the word doc with the space where I need the formula to go. The mail-merge tags above this all work great. My data source comes from a system called Conga which is a 3rd party app used in salesforce. Templates for it are made is MS Word. Is it possible to do this formula here?


Any help much appreciated!
Attached Files
File Type: docx Meals letter 2016 revised (6).docx (26.0 KB, 5 views)
Reply With Quote
  #2  
Old 10-31-2016, 04:45 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,394
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You should be able to do that with a simple field formula, encoded as:
{QUOTE {=B2-B4 \# "$,0.00"}}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues.

To see how to do a wide range of math calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party

To see how to do a wide range of date calculations in Word, check out my Microsoft Word Date Calculation Tutorial, at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled ''. Do read the document's introductory material.

You'd also do well to check out my Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
http://www.msofficeforums.com/mail-m...ps-tricks.html
or at:
http://windowssecrets.com/forums/sho...ips-amp-Tricks
That said, when you're using a third-party product, what you can achieve is often limited by that product's capabilities.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 10-31-2016, 05:33 PM
ayupchap ayupchap is offline Mac OS X Office 2013
Novice
 
Join Date: Oct 2016
Posts: 6
ayupchap is on a distinguished road
Default

OK this is amazing thanks so much! This has worked it seems!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
Word Count Formula clau_dos Word VBA 1 08-27-2013 02:05 PM
formula in Word vishalvijayan Word 2 04-01-2011 07:46 AM
Help with Word table formula fritman99 Word Tables 1 09-02-2009 05:36 PM


All times are GMT -7. The time now is 06:10 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft