Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Mail Merge Apostrophe

  • Please log in to reply
1 reply to this topic

#1 spamautodeleter


  • Members
  • 11 posts
  • Local time:12:30 PM

Posted 23 July 2008 - 11:15 PM

In a mail merge, how do you write the IF statement to deal with the possessive case?

If you are trying to write a paragraph for a mail merge document using the possessive, how do direct MS Word 2007 to use " 's " or simply " ' "? For example, I have 2 names in my data source, Smith and Jones. I want to write the sentence, "[Name]'s bonus will be $500."

For Smith, the sentence reads correctly as, "Smith's bonus will be $500."

For Jones, the sentence uses incorrect grammar, "Jones's bonus will be $500."

It should be Jones' with a simple apostrophe and no "s".

I could deal with the problem in Excel, but I keep getting an updated data source and don't want to continue to edit the spreadsheet.

Any help would be great!
Thank you.

BC AdBot (Login to Remove)


#2 jgweed


  • Members
  • 28,473 posts
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:12:30 PM

Posted 24 July 2008 - 09:11 AM

You might be pleased with this:
See also the Chicago Manual of Style, 6.8, where possessives of singular nouns (such as names) are almost always formed by 's, as in Burns's poems.
Whereof one cannot speak, thereof one should be silent.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users