newbie question - VBA - mailmerge

[GS]

I'm doing a mail merge in Word. I'm using the last name to indicate
possession, but the following passage will not be gramatically correct if the
LastName field
ends in "s" (or "z"):


"This is to confirm receipt of payment for «FirstName» «LastName»
's tuition deposit. "


If the LastName ends in an "s" or a "z" then (to be gramatically correct) I
have to change the apostrophe-"s" to just a plain apostrophe. How can I do
this in VBA?

Thanks in advance.

 

[Word Heretic]

G'day "GS" <[email protected]>,

After running the mailmerge you run a little macro that does a find on
s's and replaces it with s'.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


GS reckoned:

 

[gs]

I was hoping that I could programatically do this automatically at the time
the mailmerge was executed- with no user intervention. The program would scan
the last-name for an "s" or a "z" in the last letter of the name. If so, it
would write an apostrophe, otherwise it would write an apostrophe-s ('s).
Anybody out there know how to do this in VBA?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Z3M=?=,

I was hoping that I could programatically do this automatically at the time
the mailmerge was executed- with no user intervention. The program would scan
the last-name for an "s" or a "z" in the last letter of the name. If so, it
would write an apostrophe, otherwise it would write an apostrophe-s ('s).
Anybody out there know how to do this in VBA?

Version of Word involved?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail