Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JB reluctantly from WP JB reluctantly from WP is offline
external usenet poster
 
Posts: 5
Default Mergefield suppress if data field blank

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!)
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there no conditional line print function or variable? FUBARinSFO Mailmerge 2 October 25th 06 02:46 PM
Supress blank lines Jan Mailmerge 5 March 6th 06 03:52 PM
print field data only for forms option prints a blank page Ken Microsoft Word Help 6 October 6th 05 10:05 PM
Unwanted spaces in address on envelopes jen Mailmerge 3 September 26th 05 05:37 AM
If then else containing value not at the end or in the beginning Gert Raes Mailmerge 3 July 13th 05 02:28 PM


All times are GMT +1. The time now is 11:57 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"