[eggerist]

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_lab...th_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
Word MVP web site http://word.mvps.org



"eggerist" wrote in message
...
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"

[eggerist]

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.

"Graham Mayor" wrote:

See http://www.gmayor.com/mail_merge_lab...th_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
Word MVP web site http://word.mvps.org



"eggerist" wrote in message
...
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"

[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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"eggerist" wrote in message
...
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.

"Graham Mayor" wrote:

See http://www.gmayor.com/mail_merge_lab...th_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
Word MVP web site http://word.mvps.org



"eggerist" wrote in message
...
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]

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
Word MVP web site http://word.mvps.org



eggerist wrote:
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.

"Graham Mayor" wrote:

See http://www.gmayor.com/mail_merge_lab...th_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
Word MVP web site http://word.mvps.org



"eggerist" wrote in message
...
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"