+ Reply to Thread
Results 1 to 6 of 6

Mail Merge - changing pronoun according to gender

  1. #1
    Registered User
    Join Date
    05-27-2015
    Location
    US
    MS-Off Ver
    Office 2013
    Posts
    16

    Mail Merge - changing pronoun according to gender

    Problem: I have a Mail Merge-based Word template which is currently using masculine pronouns as the default. I would like to make the document change it to female according to a gender Match Field (e.g., change "he" to "she", "him" to "her", etc.).

    Attempted solutions: I tried to use an IF THEN ELSE condition in the Mail Merge ribbon but that wouldn't allow me to make the changes needed: I entered "Gender" as the condition but I could not further specify it to change "he" to "she" for example.

    I may be going about the above approach incorrectly, however. Any idea on how I can fix this? TIA.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge - changing pronoun according to gender

    Depending on the required text, you could use fields coded as:
    {IF{MERGEFIELD Gender}= F "her" "his"}
    {IF{MERGEFIELD Gender}= F "she" "he"}
    {IF{MERGEFIELD Gender}= F "Ms" "Mr"}
    or
    {IF«Gender»= F "her" "his"}
    {IF«Gender»= F "she" "he"}
    {IF«Gender»= F "Ms" "Mr"}
    Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown. The spaces represented in the field construction are all required.

    If you want the same gender-specific text in multiple locations, you could replicate the field in each location or you could bookmark the first of each type, then cross-reference the bookmark(s) for the others.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    05-27-2015
    Location
    US
    MS-Off Ver
    Office 2013
    Posts
    16

    Re: Mail Merge - changing pronoun according to gender

    The former set of instructions/field codes worked great. Although the font size, etc. changed afterwards, I'm sure I can fix that with some Googling. Thanks!

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge - changing pronoun according to gender

    The font usually reflects the underlying paragraph Style. If you've overridden that with hard-formatting (not recommended), the font may thus not reflect that used for the rest of the underlying paragraph. You may be able to get the desired results by adding a Charformat switch to each field (e.g. {IF{MERGEFIELD Gender}= F "her" "his" \* Charformat}) and formatting the IF with the desired font attributes.

  5. #5
    Registered User
    Join Date
    05-27-2015
    Location
    US
    MS-Off Ver
    Office 2013
    Posts
    16

    Re: Mail Merge - changing pronoun according to gender

    I think that worked. It was helpful to see an example of the statement.

    It is cumbersome to rewrite the statement(s) for pronouns in the entire document. Perhaps macros would help this issue - I should probably read up on this in the future.

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Mail Merge - changing pronoun according to gender

    I doubt macros are the way to go here. Replacing pronouns with fields throughout the document can be done with Find/Replace. For example, supposing you want to replace all instances of 'he' with the field to conditionally display she/he, simply copy the field you want to replicate to the clipboard, then use:
    Find = he
    with the match case & match whole word options, and:
    Replace = ^c

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 06-24-2015, 02:34 AM
  2. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  3. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  4. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  5. Pivot Formula: Gender(male)/Gender(female)
    By peterso in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2011, 04:23 PM
  6. Replies: 0
    Last Post: 04-21-2006, 03:40 PM
  7. [SOLVED] How do I keep the date from changing format in a mail merge?
    By Brynn Wilson in forum Excel General
    Replies: 1
    Last Post: 06-09-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1