Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-12-2012, 10:51 PM
macropod's Avatar
macropod macropod is offline 'If... then... else' - output dependent on multiple fields Windows 7 64bit 'If... then... else' - output dependent on multiple fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Hi SiBrad,

For the first issue, encode the field as:
{IF{MERGEFIELD No_of_Children} > 1 "they" "{IF{MERGEFIELD Gender_of_Child}= "F" "she" "he"}}
or:
{IF«No_of_Children» > 1 "they" "{IF«Gender_of_Child»= "F" "she" "he"}}

For the secondfirst issue, encode the field as:
{IF{MERGEFIELD X} = {MERGEFIELD Y} "text for equal" "text for NOT equal"}
or:
{IF«X» = «Y» "text for equal" "text for NOT equal"}

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple identical fields snorkerz Word 4 06-25-2012 02:30 PM
Auditing Dependent Cells WildBill Excel 2 09-07-2011 10:14 AM
'If... then... else' - output dependent on multiple fields Automatic, Dependent Cell Values flackend Excel 2 08-26-2011 07:01 AM
Merge Fields, Pictures and output to email (with attachment) schilds71 Mail Merge 0 10-21-2010 12:02 PM
How to create a Dependent Drop-Down Picklist ComcoDG Word 2 03-17-2009 07:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:39 PM.


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