Re: If statement using switches in Mergefields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Greg Maxey (gmaxey_at_whamspammvps.org)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 17:51:19 -0400

Naina,

I don't know if that is possible. A work around would be a find and
replace.

Edit>Replace>More>Use Wildcards

Type O'[a-z] in the find what field
Type ^& in the replace with field then press Format>Font and check all caps

Replace all. 

-- 
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org
Naina Haria wrote:
> Dear All
>
> Can anyone out there write an If statement for me please?
> This is my problem.  I have a merged word document in
> Word97, the data that is merged to the document comes from
> a database where the data is keyed in capital letters.
> When it is merged to word, all the names and addresses are
> in capitals. I have found using the Help file how to add a
> switch that will convert the first letter of each word to
> capitals but changes all the other letters to lowercase.
> The switch is \*Caps.  I now need to write an If statement
> that will allow me to do the same with a name that has an
> apostrophe in it. For example, Mrs O'Connor. If the
> information is merged like MRS O'CONNOR, I want to be able
> to add a switch that says if {mergefield
> Custsurname\*caps} but if {mergefield O'CONNOR, then
> make "O"\*caps and "C"*caps but only when there is an
> apostrophe in the name. I have tried writing this code but
> not had much luck.
>
> Any one who can give me any assistance, it will be greatly
> appreciated.
>
> thanks
>
> Naina

Relevant Pages

  • Re: If statement using a switch in mail merge
    ... > switch that will convert the first letter of each word to ... > capitals but changes all the other letters to lowercase. ...
    (microsoft.public.word.conversions)
  • If statement using switches in Mergefields
    ... capitals but changes all the other letters to lowercase. ... The switch is \*Caps. ...
    (microsoft.public.word.mailmerge.fields)
  • If statement using a switch in mail merge
    ... capitals but changes all the other letters to lowercase. ... The switch is \*Caps. ...
    (microsoft.public.word.conversions)
  • If statement using switches in Mergefields
    ... As I remember correctly there is also a switch "\* Lower" ... >capitals but changes all the other letters to lowercase. ... >to add a switch that says if {mergefield ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Please print clearly
    ... you should print in all capital letters (block capitals). ... Did they teach you to print as well as do cursive writing? ... anything about capitals or block letters, ...
    (alt.usage.english)