Auto Letter

[Hannes]

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.??

[kfawcett]

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