Home > Mail Merge > Word 2013 Mail Merge Suppress Blank Lines

Word 2013 Mail Merge Suppress Blank Lines


With WordWriter, a blank line is not automatically removed. This used to be under the Tools menu in previous versions: On the Tools menu, click Mail Merge. All you have to do, for example, is put «Address2» on a line all by itself (with no spaces or punctuation added) and then hit "Enter" (no shift). Join Now For immediate help use Live now! news

In the address area of my forum I want to skip address 2 if the client does not have address 2 in their client record. I've already got if/else statements in there to deal with spouses (eg. Constant Contact Review Join.Me Review LiquidPlanner Review Microsoft Office 2016 Review Microsoft Office For Mac Review Microsoft Office 365 Review Vivantio Pro Review Wrike Review Zoho Projects Review Cameras & Photo/Video In the Merge dialog box, under When Merging Records, click either: Don't print blank lines when data fields are empty. -or- Print blank lines when data fields are empty.

Word 2013 Mail Merge Suppress Blank Lines

Any update on how to accomplish suppressing blank lines? It's not on the keyboard and I can't find it in Insert. Wednesday, May 08, 2013 11:07 PM Reply | Quote 0 Sign in to vote Basically, you can't. PCMag Digital Group PC, PC Magazine and PC PCMag.com are among the federally registered trademarks of Ziff Davis, LLC and may not be used by third parties without explicit permission.

I guess we all do whatever works best for us. See attached. I don't know why it doesn't work, but we could try a workaround. Suppress Blank Lines In Mail Merge Word 2007 Yes, really.

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 I created a new merge document and all it has in it is «First_Names» «Last_Names» «Children» «Street» «City», «State» «Zip» «Telephone» «Next Record» I saved the doc in docx format and Is it possible to pay a visit to only ONE synagogue in Prague? ,,bis Sonntag'': is Sunday included or excluded? Friday, August 19, 2011 4:18 PM Reply | Quote 1 Sign in to vote With the switches, you can use whatever you want for the conditional output (eg {MERGEFIELD SpouseName \b

Privacy Policy Support Terms of Use Skip to content Braiden's way Live & Love George in Technology November 2, 2012November 2, 2012 199 Words Suppress blank line during Mail Merge Suppress Blank Fields In Mail Merge Word 2016 If the result is not single line-spaced, adjust this in the Paragraph dialog box. #5 12-21-2013, 08:33 PM macropod Windows 7 32bit Office 2010 32bit Administrator Join Date: 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. Have you tried it?

Suppress Blank Lines In Mail Merge Word 2016

This is the sort of challenge that bytes What's the most advanced weapon a time traveler from the 21st century could make with the technology of the Middle Ages? NO coding required. Word 2013 Mail Merge Suppress Blank Lines Are you actually Executing (Finishing) the merge, or just previewing it? Mail Merge Skip Blank Fields Word 2013 Friday, February 25, 2011 3:35 PM Reply | Quote 0 Sign in to vote This worksfor 2010: Click on "Replace" (as in Find/Replace) Click on "More >>" (to open up the

Thursday, April 26, 2012 12:44 PM Reply | Quote 0 Sign in to vote Hi, I am sorry to bug, but I can't find that post and I have the same http://midsolutions.org/mail-merge/mail-merge-if-blank-skip.html However when the email address is too long for the line, word is putting a line break in but this is after"e:" which is left behind. I'm dealing with names. But the result of an IF field is never treated as blank. If Mergefield Is Blank

This is a Word forum, after all. The use of the \f switch has been covered before ... Keep in touch with Experts ExchangeTech news and trends delivered to your inbox every month Live Consultants Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an More about the author Selecting the field and pressing Shift F9 will reveal: {MERGEFIELD Data} If you code the mergefield as: {MERGEFIELD Data \b "¶
"} (where ¶ is a pargraph break) it will insert

Thank you for your time. Mail Merge Helper Word 2013 In Microsoft Word, a blank line generated during a mail merge can be suppressed using application settings. You might also note that the thread to which you were replying was last updated nearly three months ago.

Wednesday, February 27, 2013 7:14 PM Reply | Quote 0 Sign in to vote Hi, I am sorry to bug, but I can't find that post and I have the same

  1. Which ended up looking like... ?activedocument.MailMerge.SuppressBlankLines and then hit Enter. «First_Names» «Last_Names» «Children» «Street» «City», «State» «Zip» «Telephone» «Next Record» At both times I still got the blank line when
  2. It's the first post I made in this thread...Cheers Paul Edstein [MS MVP - Word] Wednesday, February 27, 2013 10:18 PM Reply | Quote 0 Sign in to vote Hello, How
  3. There, once the mailmerge main document has at least one mergefield, you can click on the 'Merge' button and choose between: • Don't print blank lines when fields are empty; and
  4. Each field of a mailing address may be represented by a merge field.
  5. Thursday, August 26, 2010 3:01 PM Reply | Quote 0 Sign in to vote yes, indeed, it does not work.
  6. But one annoying aspect of the merge is that when there are extra spaces where the prefix, middle name, and suffix fields are supposed to be, I have to manually delete
  7. This worked, and as you said, don't ask me how but it worked.
  8. Press F9 again when you're done.
  9. I echo ColchesterGuide by saying what was wrong with the old method that worked perfectly with a check box to ignore blank fields.

ext_b1 is True and borrower_1 is not blank ) insert borrower_1 followed by a paragraph mark End If If so, and ext_b1 is always the same non-blank value when it is more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed and using a space within it cannot be used to suppress blank lines, which is what this thread is about.Cheers Paul Edstein [MS MVP - Word] Thursday, January 09, 2014 11:32 Word 2013 Don't Print Blank Lines When Data Fields Are Empty In Word 2007, click the Microsoft Office Button, and then click Word Options > Customize.

Privacy statement  © 2017 Microsoft. You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). You are right, you can add the mail Mail Merger Helper, and it clearly says there to Suppress Blank Lines in Address, but it doesn't suppress them. click site 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

share|improve this answer answered Dec 4 '15 at 17:54 Simon Fox 111 add a comment| up vote 0 down vote Fixing this kind of problem by manipulating the data source (e.g. I understand the switches but cannot seem to get them to work. Tuesday, December 17, 2013 9:54 PM Reply | Quote 0 Sign in to vote I just tested using the address block (which I never use). LinkBack Thread Tools Display Modes #1 09-05-2013, 03:57 AM 0nyx175 Windows 7 64bit Office 2010 64bit Novice Join Date: Aug 2013 Posts: 3 Suppress blanks in mail merge

GSM Huawei Honor 5X HTC Desire 626 Huawei P8 Lite iPhone 6 vs. 6s Nokia Lumia Samsung Galaxy J3 Samsung Galaxy S7 Samsung J7 Samsung S7 Sony Xperia Tablets Back Best But HOW THE HELL is a "normal" user supposed to figure this out. if the field is blank you will automatically have no spaces. Password Register FAQ Today's Posts Search Search Forums Show Threads Show Posts Tag Search Advanced Search Go to Page...

Your line should than look like this with the paragraph mark now visible: { MERGEFIELD Children }¶ You need to test the field value and only include its text and the 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