Empty cells of data translated to a zero in a mail-merged document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carol H - 19 Jul 2005 18:52 GMT

We recently completed a mail merge to labels. We had trouble with one
variable. We use a multiple column system for zip code, where the 5-digit zip
code, the dash and the plus-4 code are in seperate columns. When the variable
data was merged to the final word document, all of the empty cells for one of
the plus-4 variables was translated to zeros, so we ended up with a 6-digit
zipcode on any label that would not have a plus-4 zip code. Has anyone had
something similar happen? Can anyone tell me why this happens? ...and know a
fix for the problem?

Reply to this Message

Doug Robbins - 19 Jul 2005 19:09 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

But given the arrangement of your data, you will need to modify the method.

Signature

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

>
> We recently completed a mail merge to labels. We had trouble with one
[quoted text clipped - 10 lines]
> a
> fix for the problem?

Reply to this Message

Rate this thread: