Mail merge label field

[Guest]

I set up labels for show exhibitors.
Some have company names, some do not.
A blank company fielD prints "NEED COMPANY NAME"
How do I hide "NEED COMPANY NAME"

 

[Graham Mayor]

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

If the data source has NEED COMPANY NAME inserted for each record where
there is no company name, rather than just left blank, you could insert the
field conditionally eg

{IF{Mergefield Company} <> "NEED COMPANY NAME" "{Mergefield Company}"}

All brackets {} are inserted with CTRL+F9. Change the field name to match
your actual field name.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

Too advanced for my skill level.
Some Exhibitors have a company name some are individuals.
It would be easier to leave the company name field empty if there is no
company name.

 

[Suzanne S. Barnhill]

It's going to be just as complex to leave the field blank as it is to skip
it altogether. If the field were blank in the data source, then it would be
easy.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Graham Mayor]

Too advanced for your skill level? How difficult is

{IF{Mergefield Company} <> "NEED COMPANY NAME" "{Mergefield Company}"}

All you have to ensure is that you have the correct field name from your
data file shown here as Company and that you use CTRL+F9 to insert the
bracket pairs {}. i.e. you cannot simply cut and paste from here.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>