Home > Mail Merge > Word 2010 Suppress Space When A Merge Field Is Empty

Word 2010 Suppress Space When A Merge Field Is Empty

Contents

Typically, the second line of the address is optional. Below is an example of how it is merging. Starting with 2007, MS screwed everything up. The Science of Tearing Paper-bag Handles Sci-fi book I read as a kid In which episodes did the Enterprise boldly go where no-one had gone before? More about the author

In Microsoft Word, a blank line generated during a mail merge can be suppressed using application settings. DIDN'T WORK: While I was setting up my fields, I was pressing shift-enter between the fields to get them nice and close on the labels. Thursday, January 09, 2014 11:01 PM Reply | Quote 0 Sign in to vote I know this is an old post but for those looking today: remove spaces between your fields The time now is 04:34 AM. -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top Powered by vBulletin Version 3.8.1Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

Word 2013 Mail Merge Suppress Blank Lines

Advertisements Like this:Like Loading... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are Amongst other things, it doesn't work unless each line is a separate paragraph, which compromises any Style-based document formatting such as space before/after, indents, etc, all of which increase the difficulty

Attached Files Mail Merge Test.doc (28.0 KB, 31 views) __________________ Cheers, Paul Edstein [MS MVP - Word] « Previous Thread | Next Thread » Thread Tools Show Printable Version Display Modes In the case of suppressing blank lines in a simple address list, however, the easy way I have described has never failed me. objDoc.MailMerge.SuppressBlankLines Is the line completely blank? (i.e.) not like: Children: «Children» 0 Message Author Comment by:tparrett ID: 372265842011-12-02 Yes the line is completely blank. Suppress Blank Lines In Mail Merge Word 2007 if spouse name is not blank, insert "&", or if job title is not blank, insert ",") so I'm not sure about how to do the proper syntax to suppress blank

Have you tried it? Suppress Blank Lines In Mail Merge Word 2016 What would you call a person who is obsessed with being "normal"? I finally understand how to do it! microsoft-word microsoft-word-2010 mail-merge conditional-statements share|improve this question asked Nov 13 '15 at 16:42 Scott Holtzman 2692312 I ended up solving this by returning Null in the 2nd field if

unused Suppress Blank Fields In Mail Merge Word 2016 To add the switch, select the «Add_2» field and press Shift-F9 to expose its code. Is there any way to use a Word field that would delete the extra space from the form letter before I perform the merge? - Jessica Forde. Want to delete blank line from those customers who have 3 line address not 4.

Suppress Blank Lines In Mail Merge Word 2016

Can you explain how to get the returns in? You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). Word 2013 Mail Merge Suppress Blank Lines Click Cancel instead. Mail Merge Skip Blank Fields Word 2013 Edited by Voyager407 Tuesday, December 17, 2013 2:03 AM Proposed as answer by Voyager407 Tuesday, December 17, 2013 9:55 PM Tuesday, December 17, 2013 2:00 AM Reply | Quote 0 Sign

Thanks. my review here Tuesday, December 17, 2013 10:18 PM Reply | Quote 0 Sign in to vote Yes, I have tried it and it is not reliable. Where there is no middle initial or spouse name, word is leaving the spaces there. Conversely, if you code the mergefield as: {MERGEFIELD Data \f "¶
"} it will insert the paragraph break after the mergefield if the field is not blank. If Mergefield Is Blank

Here's the issue I have an Excel Spreadsheet with Names, Addresses, etc. Likely I will have blank MinistryPlace and blank MinistryAddress2 appear in various recordsfrom the SQL data I have gathered/saved in excel and use this to merge with the WORD mergefields. MSOfficeForums.com is not affiliated with Microsoft LinkBack LinkBack URL About LinkBacks MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses click site I have been lurking on several forums trying to solve this issue, but all solutions don't work.

Is it possible to pay a visit to only ONE synagogue in Prague? ,,bis Sonntag'': is Sunday included or excluded? Mail Merge Helper Word 2013 That will let you handle every kind of name from Sinbad to Doctor Martin Luther King Jr. - Neil J. Repeat for the other fields.

MERGEFIELD fields that have a blank result are treated as blank.

  • Required fields are marked *Comment Name * Email * Website PowerPointWriter Video Resources Blogged Contact Us! Recently How to Use PageSetup Options When Saving to a PDF Document
  • Forbidden.You don't have permission to view this page.https://www.quora.comPlease email [email protected] if you believe this is an error.
  • Are you actually Executing (Finishing) the merge, or just previewing it?
  • More» More Stories by Neil J.
  • Is the proof correct?

Ridiculous. Davis Steve Marx OfficeWriterHow to save an Excel Workbook to PDF with OfficeWriter - https://t.co/MW83FGHMtc 03:20:27 PM March 29, 2016 from Twitter Web Client ReplyRetweetFavoriteNew release- OfficeWriter V10 has support for To deal with that, what you can do is insert the paragraph mark inside the If "is true result" and put all the { } IF fields on one line, like Word 2013 Don't Print Blank Lines When Data Fields Are Empty Can someone please give me step by steps on how to fix this?

I guess we all do whatever works best for us. To add the Mail Merge Helper command in the Quick Access Toolbar in Word 2007, follow these steps: a. It's as simple as that. navigate to this website It has six lines including two address lines.

Related Post navigation Thanksgiving and RunningThe Names ofGod Leave a Reply Cancel reply Enter your comment here... Tuesday, September 22, 2015 4:04 PM Reply | Quote 0 Sign in to vote Made an account just to thank you. A simple thing like suppressing blank lines and I have to go through all this crap?!? Is this a famous aviator / airplane?

Your posts suggests, though that you're working with data that can output variable row counts. Press F9 again when you're done. Can anyone explain this in layman's terms?