Reply
 
Thread Tools Display Modes
  #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.
  #2   Report Post  
Rounder Rounder is offline
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by Rounder View Post
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.
Got it figured out, I think
This is what I did,

I hit ALT+F9 to get squiggly parenthesis
entered {={ MERGEFIELD monthly_rent }+20}
monthly_rent was the name of my field in the document

seems to be working great.

Last edited by Rounder : January 30th 14 at 06:18 PM
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF Adi.Master Mailmerge 0 August 18th 13 11:34 PM
Multiplying a mail merge formula Grazza215 Mailmerge 0 August 13th 13 04:42 PM
Mail Merge Formula - Logic Stumped MaxArk[_28_] Mailmerge 2 June 1st 10 11:11 AM
Create formula using a merge field Seth Schwarm Microsoft Word Help 1 October 30th 06 11:59 PM
Date formula in merge Chandra Mailmerge 1 May 17th 06 06:41 PM


All times are GMT +1. The time now is 02:30 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"