If statement using switches in Mergefields
From: Gert Raes (anonymous_at_discussions.microsoft.com)
Date: 08/13/04
- Next message: robert: "mail merge tick box field from access"
- Previous message: Doug Robbins: "Re: Merging Files - Please HELP!!"
- In reply to: Naina Haria: "If statement using switches in Mergefields"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 13 Aug 2004 04:06:30 -0700
As I remember correctly there is also a switch "\* Lower"
So it should look like : {mergefield O'CONNOR \*Lower}
(but I'm not sure since I use Word2003
>-----Original Message-----
>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
>
>.
>
- Next message: robert: "mail merge tick box field from access"
- Previous message: Doug Robbins: "Re: Merging Files - Please HELP!!"
- In reply to: Naina Haria: "If statement using switches in Mergefields"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
