The best solution, in my opinion: put the whole line to print in a separate column in Excel. Using IF and FORMAT and text concatenation operator & you can finetune it as you like. Then print that column as a simple text field, like name and address.
Hope this helps.
I am using MSOFFICE XP.
I have created a merge document in Word and the data is taken from an Excel spread sheet.
I use this to printout invoices which has the information on the product, pricing, tax rate etc., and the payment received - ( by cheque, draft, credit card etc., with details)
If the payment is not received then the invoices get printed out as follows
"By Cheque for Rs. 0.00 Cheque No of dated 12:00:00 AM"
Essentially I want to suppress this line from printing when payment is not received.
How do I do that ?