form letters

[Guest]

I'm using Word 2000 and have used mail merge and form letters for years. I
create my form letter in Word and link it to an Excel data source. For some
reason the program is allowing blank lines in the merged document when the
data cell is empty, even though I check "do not allow blank lines..." box at
merge time. What is causing this?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?TmFuY3k=?=,

I'm using Word 2000 and have used mail merge and form letters for years. I
create my form letter in Word and link it to an Excel data source. For some
reason the program is allowing blank lines in the merged document when the
data cell is empty, even though I check "do not allow blank lines..." box at
merge time. What is causing this?

If you have anything at all in the line (such as an IF or another field that you
can't see), then the line won't be suppressed. This hasn't been the same across
all versions of Word, but in the more recent ones, it's the case.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?TmFuY3k=?=,

I'm using Word 2000 and have used mail merge and form letters for years. I
create my form letter in Word and link it to an Excel data source. For some
reason the program is allowing blank lines in the merged document when the
data cell is empty, even though I check "do not allow blank lines..." box at
merge time. What is causing this?

If you have anything at all in the line (such as an IF or another field that you
can't see), then the line won't be suppressed. This hasn't been the same across
all versions of Word, but in the more recent ones, it's the case.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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