Mergefield suppress if data field blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JB reluctantly from WP - 16 Nov 2006 20:19 GMT

Hello,

I have an Excel database file, and am merging into a Word document. I am
familiar with Word's merge process. However, I have a field in the database
called RADIO that is a 3-digit number, or the field may be blank. The Word
document displays the blank fields as a zero. I want them to be blank. I
have read previous posts about using switches within my mergefield, and they
kind of make sense, but none seem to be the right fix for my particular need.

Currently displayed in Word document: {Mergefield "Radio"}
I need this to only display text if not blank in database.

Any assistance is greatly appreciated!

Julie ~ reluctantly switching from WordPerfect to Word (sheesh!)

Reply to this Message

Cindy B - 16 Nov 2006 21:17 GMT

I’ve seen a lot of inconsistencies with newer versions of word as well. I
would suggest creating an If Then Else statement to control the field. “If
mergefield is not blank then insert otherwise do nothing”

Good luck.

Reply to this Message

macropod - 16 Nov 2006 21:30 GMT

Hi JB,

You can fix this by adding a numeric picture switch to the field. To do
this:
. select your mergefield and press Shift-F9 to expose the code. It should
look something like:
{MERGEFIELD ExcelData}
where 'ExcelData' is you field name
. delete anything after 'ExcelData' and add '\# 0;;') to the field so that
you've got:
'{MERGEFIELD ExcelData \# 0;;}'
. press F9 to update the field
. run your mailmerge

Cheers

Signature

macropod
[MVP - Microsoft Word]

> Hello,
>
[quoted text clipped - 11 lines]
>
> Julie ~ reluctantly switching from WordPerfect to Word (sheesh!)

Reply to this Message

JB reluctantly from WP - 16 Nov 2006 22:03 GMT

Macropod,

Thank you so much! I knew I didn't have to make long complicated IF, THEN,
ELSE statements to get the result I wanted! I really appreciate your help.

~Julie

> Hi JB,
>
[quoted text clipped - 31 lines]
> >
> > Julie ~ reluctantly switching from WordPerfect to Word (sheesh!)

Reply to this Message