If-fields in a bulleted list in a Word mail-merge document

[Helga.Jewell]

I have a bulleted list of 6 items which depend on fields
being blank or not blank in an Excel spreadsheet. The If-
statements work, however, the word document displays blank
lines with bullets. How can I tell word not to print the
blank lines.

With thanks for your help.
Regards
Helga Jewell

 

[Graham Mayor]

Include the line feed in the conditional result so that it is only present
when the condition is true.
eg
{IF {Mergefield FieldName1} <> "" "
Do this"}{IF {Mergefield FieldName2} <> "" "
Do this"}etc

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


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

 

[Helga]

Dear Graham
Thank you very much for your advice, however, I still
can't get it to work. Is there a possibility of sending
you the document and attached spreadsheet sample? In your
example, what represents the line feed?
Regards
Helga

 

[Graham Mayor]

I am away from my office until the end of next week so I cannot accept
documents at present.
Obviously you need to change the field names to those in your data file and
the curly brackets are inserted with CTRL+F9. The line feed is inserted by
pressing the enter key at the required places. Does that make it any
clearer?

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


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