Doug Robbins - Word MVP said:
In the mailmerge main document, use the following If...then...Else field
construction:
{ IF { MERGEFIELD fieldthatmightbeblankname } = 0 " " { MERGEFIELD
fieldthatmightbeblankname } }
You must use Ctrl+F9 to insert each pair of field delimiters and Alt+F9 to
toggle off their display.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
This is not very workable. I have the same problem as the original poster
(OP), and my mail merge document is very large and already contains many
conditional fields. The grade reports for our school are prepared as a mail
merge document with the data maintained in MS Excel spreadsheets. In some
fields the student has an elective option, so I use IF..THEN..ELSE Word
fields to contain the choices of different possible data base fields.
This setup worked as expected in Word 2.0, Word 3.0, Word 5.0, Office 95,
Office 98, and Office 2000. The behavior is broken in Office 2003.
I have thought of trying to insert a numerical picture at the end of the
field statement, but this is making already complex statements even harder to
understand. As I recall, the picture I added was something like "\#
####;'';''", using paired single quotes to represent the null string.
I would really appreciate any suggestions for a simpler solution. I have
work-arounds, but they are all irritating.