Re: If statement using a switch in mail merge

From: Ian Roberts (nospam_at_NOSPAM.com)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 13:49:39 +0100

"Naina Haria" <anonymous@discussions.microsoft.com> wrote in message
news:4ece01c4805e$dd536dd0$a401280a@phx.gbl...
> 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

----- Original Message -----
From: "Naina Haria" <anonymous@discussions.microsoft.com>
Newsgroups: microsoft.public.word.conversions
Sent: Thursday, August 12, 2004 12:24 PM
Subject: If statement using a switch in mail merge

> 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

Hi Naina

Try posting your message in the NG...

microsoft.public.word.mailmerge.fields

I think there's more chance of getting an answer there.

Good luck

Ian

Relevant Pages

  • 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
    ... capitals but changes all the other letters to lowercase. ... The switch is \*Caps. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: If statement using switches in Mergefields
    ... A peer in "peer to peer" support ... 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. ...
    (microsoft.public.word.mailmerge.fields)
  • 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: MUSCLE IMPLANTS!!!!
    ... With the help of some friends, I even have my own word game online at ... We named the game Switch. ... switch, add, or subtract letters to make another word. ...
    (misc.fitness.weights)