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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan Gilson - 16 Nov 2004 15:53 GMT

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.

Reply to this Message

Cindy M -WordMVP- - 18 Nov 2004 09:14 GMT

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 :-)

Reply to this Message