Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2014, 03:31 AM
Mulith Mulith is offline Include block of text with merge fields. Windows 7 32bit Include block of text with merge fields. Office 2010 32bit
Novice
Include block of text with merge fields.
 
Join Date: Oct 2014
Posts: 15
Mulith is on a distinguished road
Default Include block of text with merge fields.

I'm currently putting together a statement for our customers which includes a section showing rent arrears if any exist. What ~I'd like to do is exclude the section all together if there are no arrears and only show it if the tenant has rent arrears.



See attached for what we currently use.



I'd like to check the <<RentInArrears_AmountOutstanding>> for a value creater than 0. If this condition is true then include the block of text and the table in the attached file.

Is this possible?
Attached Files
File Type: docx arrears.docx (14.2 KB, 8 views)
Reply With Quote
  #2  
Old 10-30-2014, 03:42 AM
macropod's Avatar
macropod macropod is offline Include block of text with merge fields. Windows 7 64bit Include block of text with merge fields. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,938
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached.
Attached Files
File Type: docx arrears.docx (19.7 KB, 7 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-30-2014, 03:59 AM
Mulith Mulith is offline Include block of text with merge fields. Windows 7 32bit Include block of text with merge fields. Office 2010 32bit
Novice
Include block of text with merge fields.
 
Join Date: Oct 2014
Posts: 15
Mulith is on a distinguished road
Default

Ahh brilliant, expanded this to incase the table and it worked! Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Email Merge to include CCs, with 1 attachment instead of many Auslegung Mail Merge 0 06-12-2013 03:20 PM
Include block of text with merge fields. Text Box Merge Fields agentwright007 Mail Merge 1 03-22-2012 07:20 AM
Merge Fields and Static Text kbranden Mail Merge 1 06-15-2011 09:02 AM
Include block of text with merge fields. Mail Merge truncating 'some' of the text fields......Not sure what to do sssb2000 Mail Merge 5 09-26-2010 09:40 AM
Mail Merge Fitting Text to Fields frnk4760 Mail Merge 1 05-18-2010 04:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft