A '0' is added in every blank field in mail merge

[Susan Gilson]

Mass mailing
When merging information from Microsoft Works to Microsoft Word document,
the fields that do not contain any information are replaced by a zero (0). I
want to disenable this, as it comes up on the letter and is not suitable for
mailing.

I would like the other merge fields to compensate for this and move up.

 

[Cindy M -WordMVP-]

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

When merging information from Microsoft Works to Microsoft Word document,
the fields that do not contain any information are replaced by a zero (0). I
want to disenable this, as it comes up on the letter and is not suitable for
mailing.

I would like the other merge fields to compensate for this and move up.

Catalog type of merge, I take it? Version of Word?

Probably, you're going to need an IF field to test the value and display what
you want to have as the result. For example:

{IF {Mergefield Amount} <> "0" "{Mergefield Amount}¶
" "" }

Where ¶ is where you press ENTER for a new line (new lines only when it
evaluates to true). Ctrl+F9 to insert the { field brackets }; Alt+F9 to toggle
field codes off/on.

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