Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] kim.braun@gmail.com is offline
external usenet poster
 
Posts: 2
Default Complex merge fields/IF statements

(Apologies for cross-posting.)

I would appreciate some help in constructing more complex IF statements with merge fields in a Word merge (Word 2010). I have tried various attempts on my own based off of this site, but without getting the results I'm looking for: http://word.mvps.org/faqs/mailmerge/mmergeiffields.htm

ISSUE 1:
I would like to display the "Title" field only if it is NOT Mr., Mrs., Miss, or Ms. I only want OTHER titles to display (examples are Dr., Col., but those aren't the only ones; they can vary).

I tried this with only two of the four titles that I don't want as an example, but it isn't working properly:
{IF {MERGEFIELD Title}="Mr." {IF {MERGEFIELD Title}="Ms." "" {MERGEFIELD Title}}}

ISSUE2:
I would like to display the year that someone graduates (their "ClassYear" field). Usually, this is one year, but sometimes there is a graduate who earned two or three degrees. I want to show "ClassYear2" or "ClassYear3" (and a comma preceding each of them) only if there is content in those fields.

ISSUE3:
Spacing issues. I have a MiddleName and a NickName field that will sometimes have information, sometimes not. I want to only include appropriate spaces when either or both of those fields have content. (I imagine this is similar to the comma issue above.)

Thank you for any assistance.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Lisa Wilke-Thissen[_2_] Lisa Wilke-Thissen[_2_] is offline
external usenet poster
 
Posts: 15
Default Complex merge fields/IF statements

Hi,

[Word 2010]
I would like to display the "Title" field only if it is NOT Mr., Mrs.,
Miss, or Ms. I only want OTHER titles to display (examples are Dr., Col.,
but those aren't the only ones; they can vary).


Try {IF {MERGEFIELD Title} "Mr." "{IF {MERGEFIELD Title} "Mrs." "{IF
{MERGEFIELD Title} "Miss" "{MERGEFIELD Title}" ""}" ""}" ""}


I want to show "ClassYear2" or "ClassYear3" (and a comma preceding each of
them) only if there is content in those fields.


Use the switch \b to add a character, e.g. a comma before the field: {
Mergefield ClassYear2 \b ","}

I have a MiddleName and a NickName field that will sometimes have
information, sometimes not.


Use the switch \b to add something before a non empty field, use the switch
\f to add something after a non empty field.

--
Cheers,
Lisa

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
Help with IF statements comparing more than two fields ChristineKD Microsoft Word Help 3 December 26th 13 07:43 PM
IF Statements in Word Fields Erika Microsoft Word Help 1 August 1st 07 11:58 AM
Merge fields in IF statements not working [email protected] Microsoft Word Help 5 August 24th 06 01:41 PM
IF Statements and REF Fields Anna Cooper Microsoft Word Help 1 October 15th 05 06:12 AM
IF Fields With AND Statements Brendan Vassallo Microsoft Word Help 4 March 11th 05 02:47 AM


All times are GMT +1. The time now is 02:19 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"