Information Technology IT – 18 Mail merge | e-Consult

To implement the discount logic, a conditional field would be used to check if the 'Total Amount' is greater than £500. If it is, the letter will include a message indicating a discount has been applied, along with the discount amount. If not, the letter will simply state the total amount. Conditional Field Syntax (example): 500. This means "if the Total Amount is greater than 500, include the discount message". The letter template would then include the following conditional logic: If 500 then Discount Applied: £[Discount Amount] else Total Amount: £[Total Amount]. The 'Discount Amount' would need to be calculated separately (e.g., as a field in the spreadsheet or using a formula within the mail merge software). This ensures that the invoices are personalised with the correct discount information, improving customer satisfaction and accuracy.