IF Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John B - 21 Apr 2008 21:29 GMT

I would like to know how to go about putting in IF statement into a mail
merge? I have 2 fields, one is called Firstname and the other is called
Client. I would like to have Firstname pulled, and IF blank, then pull
Client. Any help on this would be greatly appreciated. Thanks.

John

Reply to this Message

Doug Robbins - Word MVP - 22 Apr 2008 02:45 GMT

The field construction that you will need is:

{ IF { MERGEFIELD Firstname } <> "" { MERGEFIELD Firstname } { MERGEFIELD
Client } }

Each pair of field delimiters { } must be inserted using Ctrl+F9 and you use
Alt+F9 to toggle off the display of the field codes. You will need a space
either side of the <>.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I would like to know how to go about putting in IF statement into a mail
> merge? I have 2 fields, one is called Firstname and the other is called
> Client. I would like to have Firstname pulled, and IF blank, then pull
> Client. Any help on this would be greatly appreciated. Thanks.
>
> John

Reply to this Message

John B - 22 Apr 2008 21:49 GMT

Doug,

Thanks. I remember doing something similiar to this a few years ago, but
couldn't remember how to do it. I have an addition to this though. I have
another field to add to this. As before, I would like to have Firstname
pulled, and IF blank, then pull Client, and IF Client blank, then pull
Businessname. Hope you can help with this again. Thanks.

John

> The field construction that you will need is:
>
[quoted text clipped - 11 lines]
> >
> > John

Reply to this Message

Doug Robbins - Word MVP - 22 Apr 2008 22:47 GMT

Just include another If...then...Else field construction

{ IF { MERGEFIELD Firstname } <> "" { MERGEFIELD Firstname } { IF{
MERGEFIELD
Client } <> "" { MERGEFIELD Client } { MERGEFIELD Businessname } } }

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Doug,
>
[quoted text clipped - 23 lines]
>> >
>> > John

Reply to this Message