View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How to do String Manipulations on a Merge Field?

There are no string functions such as left(), mid(), right() but you can use
wildcards at the left hand eend or right hand end of the second comparand
(but not both ends at once), e.g.

{ IF "{ MERGEFIELD myfield }" = "*1" "the rightmost character is a 1" "the
rightmost character is not a 1" }

It doesn't work for text longer than around 128 characters (or maybe 64, I
forget).

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Lynda" wrote in message
...
Is it possible to find the last or first character(s) in a mail merge
field? For example, I want to check a merge field that contains 4
characters and I just want to do an if-then-else statement on the final
character. For example, if Right(mergefield) = 1, then do something, else
do something different. I can't seem to find any information on string
manipulations in Word. I am using Word 2003.

Thanks for your help.

Lynda