BleepingComputer.com: Mail Merge Apostrophe

Jump to content

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,603
  • 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