Re: If statement using a switch in mail merge
From: Ian Roberts (nospam_at_NOSPAM.com)
Date: 08/12/04
- Next message: SK: "Word 2003 & PDF"
- Previous message: Naina Haria: "If statement using a switch in mail merge"
- In reply to: Naina Haria: "If statement using a switch in mail merge"
- Next in thread: Naina Haria: "Re: If statement using a switch in mail merge"
- Reply: Naina Haria: "Re: If statement using a switch in mail merge"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: SK: "Word 2003 & PDF"
- Previous message: Naina Haria: "If statement using a switch in mail merge"
- In reply to: Naina Haria: "If statement using a switch in mail merge"
- Next in thread: Naina Haria: "Re: If statement using a switch in mail merge"
- Reply: Naina Haria: "Re: If statement using a switch in mail merge"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
