How to Suppress Blank Lines During a Mail Merge in Word 2003

J

JAJOSEPHESQ

Does any one know how to suppress blank lines during a mail merg in
word 2003. The field in excel that the mail merge is reading from has
the following formula in it:

=IF(K2>15,"DELIVERY CONFIRMATION REQUESTED","")

if K2 is < 15, the field shows up as blank in excel. This should
mean that the mail merge in word should suppress the line. However,
when I perform the mail merge, that field appears as a zero. The
same result is occurring with the forth line of an address. In the
spread sheet, the cell shows up as being blank (via the formula I have
in it), but when I perform the mail merge, that field appears as a
zero.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format change in merge data - Bold formatting after a comma 0
Mail Merge skipping records/sending one at a time 0
Grouping Names in Mail Merge 0
Mail Merge - displaying a conditional number of decimals 5
Conditional Mail Merge won't suppress blank lines 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
How to make the shading look uniform around a double spaced line in MS Word? 0
VBA - exporting serial letters to single documents 0

Top