In mail merge I don't want to print blank fields

R

Richard

How can I surpress the printing of zeros in a field that is blank in the data
source (in this cace, Excel)
 
D

Doug Robbins

Add the following format picture switch to the field

\# "0;-0;"

--
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
 
R

Richard

Where do I actually add the switch?

Doug Robbins said:
Add the following format picture switch to the field

\# "0;-0;"

--
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher adding blank page when printing my booklet... 2
Page numbering with Merged Document and IF statements 1
Mail Merge Directory Conditional Page Break 0
Publisher is filling blank lines with data 2
Dealing with a Pivot Table (when I don't want to) 0
Printing Mail Merge Slow 0
How to display zero value in blank fields of Cross Tab query 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0

Top