View Single Post
  #1   Report Post  
Rounder Rounder is offline
Junior Member
 
Posts: 2
Default Using a formula in mail merge

Hi,
New to the forum as I am looking for an answer on using one field to change another. Not the sharpest tool in the shed so would appreciate any help.
I have created a merge document to send to tenants when it is time to renew their lease. If they don't renew the lease they go to a month-to-month payment at an increased rent of $20.00 more per month. I have inserted a field to show the current rent, say $500.00. How do I make a second field to show that the rent will increase to $520.00 if they don't renew the lease and go to a month-to-month payment schedule?

Thanks for any help available.