mail merge

[terry Kenddrick]

if a field is empty how do i tell word to insert another
field.

ex. if {contact_name} is empty How do i insert
{business_name}

thanks

 

[Graham Mayor]

You should start a new thread for a new question - not simply tack on to the
end of an existing one. Your messages are likely to be overlooked.

As for your question, you need a conditional field - entered by hand using
CTRL+F9 to set each pair of field brackets {}

{IF {Mergefield Contact_Name} <> "" "{Mergefield Contact_Name}" "{Mergefield
Business_Name}"}

ie if contact name is not empty use contact name, otherwise use business
name.

or

{IF {Mergefield Contact_Name} = "" "{Business_Name}"}

which is more literally what you asked for.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Cindy M -WordMVP-]

Hi Graham,

You should start a new thread for a new question - not simply tack on to the
end of an existing one.

Interesting... I do see Terry's message as a new thread. Maybe your newsreader
really is pulling shenanigans (or mine is)

Cindy Meister

 

[Graham Mayor]

Hi Graham,

Interesting... I do see Terry's message as a new thread. Maybe your
newsreader really is pulling shenanigans (or mine is)

Cindy Meister

Oh dear
I see it as a sub post to a message of the same name dated 4/2.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Cindy M -WordMVP-]

Hi Graham,

Oh dear
I see it as a sub post to a message of the same name dated 4/2.

Ah, OK, that makes sense. That will happen in my newsreader if I
have messages for the group with the same subject. Can be awfully
confusing...

Cindy Meister