[MikeB[_2_]]

On Feb 9, 9:27*am, "Graham Mayor" wrote:
That would be fairly simple
The game was won by {IF {Mergefield FirstName} "" "{Mergefield
Firstname}" *"{Mergefield Lastname}"}
Use the correct field names and enter all the bracket pairs with CTRL+F9
--

Graham Mayor - *Word MVP

My web sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org


"MikeB" wrote in message

...
On Feb 9, 9:09 am, MikeB wrote:



I'm doing a label merge (asked a recent question here about it). Now
I'm wondering if it is possible to apply conditions to the merge
process.

For example, if I have a field for last and first names, then I'd like
to merge the first name field into the label, but if the first name is
blank, then I'd like to substitute it with the last name.

In this example, if I have the first name field, then the line might
read.

The game was won by Mike.

If I don't have the first name field and I substitute the last name
field, the line of text should read

The game was won by Black.

Is this possible?

Thanks!

Actually, let me expand on that a little more.

Can I also vary the text inserted into the label? *For instance, if I
have a field for sender and receiver, then if the receiver field is
filled in, the text might read:

Proposed receiver: Mike Black

But if the sender field is filled in, the text *in that area might
read:

Transmitted by Joe Gorilla.

So, is either or both of these things possible in label merge
operations?

Thanks!

Graham, thank you for your quick response. Is this in the Help
somewhere? (Have I ever complained how hard I find it to get the right
help section in the new Help system in Office 2007?).

If I look at your example, then a stylized representation seems to be:

{IF {condition "{true_action}" "{false_action}"}

and then to identify "stuff" (for want of a better technical term), I
use the Mergefield identifier to name the data element in the merging
record? Sorry if I'm being vague or imprecise.

If there is a good reference for this could you please point me there?

Thanks.