IF command to insert a comma if the Title field is not blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K Hyzer - 21 Sep 2006 15:20 GMT

I am merging a mailing list to a Word letter. I will be printing the person's
name followed by their title. How do I set up the IF command to insert a
comma after the person's name if the Title field is not blank? I am using
Word 2003.

Reply to this Message

Doug Robbins - Word MVP - 21 Sep 2006 20:55 GMT

Insert and If...then...Else... field from the Word Fields toolbar, or using
Ctrl+F9 to insert the field delimiters, create the following in the document

{ IF { MERGEFIELD Title } <> "" ", { MERGEFIELD Title }" }

Use Alt+F9 to toggle off the display of field codes.

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 am merging a mailing list to a Word letter. I will be printing the
>person's
> name followed by their title. How do I set up the IF command to insert a
> comma after the person's name if the Title field is not blank? I am using
> Word 2003.

Reply to this Message

K Hyzer - 22 Sep 2006 15:01 GMT

This helped - I'm almost there. This does insert the title field, but not a
comma. This is what I put in the document:
{ IF {MERGEFIELD Title } <>"" ", {MERGEFIELD Title }" }

Any suggestions?

Thanks,
Kim

> Insert and If...then...Else... field from the Word Fields toolbar, or using
> Ctrl+F9 to insert the field delimiters, create the following in the document
[quoted text clipped - 8 lines]
> > comma after the person's name if the Title field is not blank? I am using
> > Word 2003.

Reply to this Message

Doug Robbins - Word MVP - 23 Sep 2006 05:26 GMT

You probably did not use Ctrl+F9 for each pair of field delimiters. You
cannot insert the { } by using Shift plus the number 9 and 0 number keys (US
Keyboard layout)

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

> This helped - I'm almost there. This does insert the title field, but not
> a
[quoted text clipped - 22 lines]
>> > using
>> > Word 2003.

Reply to this Message

Peter Jamieson - 26 Sep 2006 12:00 GMT

or in Word 2003, try

{ MERGEFIELD Title \b ", " }

Peter Jamieson

> This helped - I'm almost there. This does insert the title field, but not
> a
[quoted text clipped - 22 lines]
>> > using
>> > Word 2003.

Reply to this Message

Rate this thread: