BleepingComputer.com: Mail Merge Apostrophe

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.

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Mail Merge Apostrophe How to do possessives like Smith's and Jones'

#1 User is offline   spamautodeleter 

  • New Member
  • Pip
  • Find Topics
  • Group: Members
  • Posts: 11
  • Joined: 15-October 06

  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.

#2 User is offline   jgweed 

  • Forum Addict
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Global Moderator
  • Posts: 27,228
  • Joined: 11-April 04
  • Gender:Male
  • Location:Chicago, Il.

Posted 24 July 2008 - 09:11 AM

You might be pleased with this:
http://www.bartleby.com/141/strunk.html#1
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.
Cheers,
John
Whereof one cannot speak, thereof one should be silent.

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users