how to make it skip a field if it's blank

[erica]

Is there a way to make the field be skipped altogether if
there is no data in it? I'm merging data into a bulleted
list in a mail merge letter and don't want empty bullets
with no info after them if there are fewer items.

 

[Graham Mayor]

Insert the field and the paragraph mark that follows it with a conditional
field eg

{IF {Mergefield Fieldname} <> "" "{Mergefield Fieldname}
"}


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
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 Erica,

Is there a way to make the field be skipped altogether if
there is no data in it? I'm merging data into a bulleted
list in a mail merge letter and don't want empty bullets
with no info after them if there are fewer items.

Generally, the answer to this would be yes, you could
suppress a line if the field is blank. However, bullets and
numbering don't follow this rule.

However, if you create these lines using a SYMBOL (as in
Insert/Symbol) for the bullet, and nest them into IF fields,
you should get the result you're looking for. A pain to get
it all set up, I know...

Example (§ represents a bullet symbol from Insert/Symbol;
¶ represents a paragraph mark, where you must press ENTER
for the new line):

{ If { Mergefield A } <> "" "§ {Mergefield A}¶
" }{ If { Mergefield B } <> "" "§ {Mergefield B}¶
" }{ If { Mergefield C } <> "" "§ {Mergefield C}¶
" }

Remember that you need to use Ctrl+F9 to insert the pairs of
field brackets { }.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail