 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2005In mail merge I don't want to print blank fields
How can I surpress the printing of zeros in a field that is blank in the data source (in this cace, Excel) Version? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > How can I surpress the printing of zeros in a field that is blank in the data > source (in this cace, Excel) 2002 > Version? > ******************* [quoted text clipped - 6 lines] > data > > source (in this cace, Excel) Don't use the Address Block. Instead, insert the merge fields separately. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > 2002 > [quoted text clipped - 8 lines] > > data > > > source (in this cace, Excel) Add the following format picture switch to the field \# "0;-0;"  SignatureHope 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 > How can I surpress the printing of zeros in a field that is blank in the > data > source (in this cace, Excel) Where do I actually add the switch? > Add the following format picture switch to the field > [quoted text clipped - 3 lines] > > data > > source (in this cace, Excel) Hit Alt+F9, Richard. You should then be able to view the merge fields so you can edit it. See: http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > Where do I actually add the switch? > [quoted text clipped - 5 lines] > > > data > > > source (in this cace, Excel) I take it this is a number field - see http://www.gmayor.com/formatting_word_fields.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > How can I surpress the printing of zeros in a field that is blank in > the data source (in this cace, Excel) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.