Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-28-2009, 05:10 AM
Hannes Hannes is offline Auto Letter Windows XP Auto Letter Office 2003
Novice
Auto Letter
 
Join Date: Oct 2009
Posts: 1
Hannes is on a distinguished road
Default Auto Letter

I am trying to set up a financial cover letter for management reports. The idea is that the template asks a few input questions ie. what is the solvency ratio, what is the ROI etc. Once all questions have been answered in the input box(es). word should add all the answers in the relevant spaces in the letter. One problem is that it must ask for profit/los amount. If it is a positive amount then word must with an IF statement add "Profit" or "Loss" in the case of a negative amount. Any one out there able to assist.??
Reply With Quote
  #2  
Old 10-29-2009, 06:27 AM
kfawcett kfawcett is offline Auto Letter Windows 7 Auto Letter Office 2007
Advanced Beginner
 
Join Date: Sep 2009
Posts: 39
kfawcett is on a distinguished road
Default

You will be better off using Infopath if you have it. You could then use a combination of rules and XPath functions to accomplish your goal. This might not be an easy process though as it could require some programming knowledge.

Look at the last two pages of this document. It talks about calculating fields.

Blog on Conditional Values/Xpath in Infopath

Tutorial on XPath
Reply With Quote
Reply

Tags
autotext, financial, letterwriter



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto referencing SharkAttack Word 5 02-17-2013 07:09 PM
Letter Templates happymouth Word 8 05-17-2009 02:43 AM
company standard letter nicklarzn Word 0 12-17-2008 02:35 AM
capitalize first letter of sentences norco1 Word 0 06-25-2006 12:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:40 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