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

Word 2013 Mail Merge Suppress Blank Lines


Mailmerge automatically suppresses blank fields Thursday, March 24, 2016 1:31 PM Reply | Quote 0 Sign in to vote That approach does not address the problems discussed in this thread. Join Now For immediate help use Live now! I am assuming that the logic you require is along the following lines If ( ext_b1 is False or borrower_1 is blank ) don't insert anything, not even a blank line With those issues addressed, all four previews work, though Previews 2 & 3 don't honour the inter-paragraph spacing (an apparent limitation of that method). have a peek at this web-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 That is the mistake I was making, worrying about formatting (the extra space it leaves between the lines/mergefields) Just do the mailmerge making sure that when you insert the mergefields you It has six lines including two address lines. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.

Word 2013 Mail Merge Suppress Blank Lines

In order to prevent a line break if AddressLine2 is not present, do not put a line break after the AddressLine2 merge field in the WordWriter template document. I've been messing around with If statements but can only seem to get one of those - for example If address 2 is blank then print address 3 but this doesn't Sunday, March 04, 2012 8:56 PM Reply | Quote 0 Sign in to vote That sounds like a great fix, but there's no "More>>" in the "Replace" option that i can Thank you for your time.

  • 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.
  • When merged I get a blank line if there are no children.
  • Friday, December 09, 2016 6:01 PM Reply | Quote 0 Sign in to vote Word's 'skip blanks' behaviour hasn't changed.

It's as simple as that. 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: More» Panda Protection Advanced Panda Protection Advanced offers unlimited installations on your Windows and Android devices. Suppress Blank Lines In Mail Merge Word 2007 Merged date looks like this: John &Jane Doe 111 Washington Place Syracuse, NY 99999 555-999-5555 Mark &Sally Doe Daughter, Son 222 Washington Place Syracuse, NY 99999 555-888-5555 0 LVL 76

Solution: Create your merge as normal, I use the Step by Step Mail Merge Wizard, select your data source. SoftArtisans Search Primary Menu Skip to content About Tech Retro Tech Women In Tech Truth in Tech ASP.NET Excel Big Data Events OfficeWriter Knowledge Base ExcelWriter Knowledge Base WordWriter Knowledge Base If you are familiar VBA, try opening the document and typing this into the immediate window: ?activedocument.MailMerge.SuppressBlankLines and then hit Enter. Password Register FAQ Today's Posts Search Search Forums Show Threads Show Posts Tag Search Advanced Search Go to Page...

This is so overly complicated!Ikeep an old template letter which I copy over and which was originally created in Word XP I think and amend the letter text but it seems Suppress Blank Fields In Mail Merge Word 2016 This will allow you to select the Visual Basic development system and add a Module. A simple thing like suppressing blank lines and I have to go through all this crap?!? 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

Suppress Blank Lines In Mail Merge Word 2016

I don't know why it doesn't work, but we could try a workaround. Usually I have a merge set up not to print the blank lines when the data fields are empty. Word 2013 Mail Merge Suppress Blank Lines Starting with 2007, MS screwed everything up. Mail Merge Skip Blank Fields Word 2013 I finally understand how to do it!

Click All Commands in the Choose commands from, and then click Mail Merger Helper in the Choose commands from list. http://comvurgent.com/mail-merge/word-mail-merge-if-then-else-insert-field.html This used to be under the Tools menu in previous versions: On the Tools menu, click Mail Merge. Why would a conscripted army continue to fight a losing battle Why is data in computer science considered to be discrete? Can anyone explain this in layman's terms? If Mergefield Is Blank

Ordinary typed white space such as spaces and tabs are treated as blank. Back to top By Neil J. So, for this to work: the field in the data source has to be empty; the line in the Word document can only contain the mergefield; and that line must be Source 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

My initial try with the Mail Merge Helper didn't work either. Mail Merge Helper Word 2013 Q: I use Microsoft Word 2000 at work and I have been asked to create mail merges for certain projects. SEE THE WINNERS Message Author Comment by:tparrett ID: 372268582011-12-02 Thanks for all your help so far.

Check the box labeled "Text to be inserted after", type a space in the text field next to it, and click OK.

It requires the use of an IF field, so it would help to show the field codes in the document Go to Solution 4 3 2 Participants GrahamSkan(4 comments) LVL 76 Thanks. You might also note that the thread to which you were replying was last updated nearly three months ago. Word 2013 Don't Print Blank Lines When Data Fields Are Empty It was easy and obvious in Word 2000.

Best Regards, Sally Tang Marked as answer by Sally Tang Thursday, August 26, 2010 8:36 AM Unmarked as answer by dtownlake Thursday, August 26, 2010 2:59 PM Wednesday, August 18, I echo ColchesterGuide by saying what was wrong with the old method that worked perfectly with a check box to ignore blank fields. Rearrangeable Code Bowling What is the name of this effect used in Flags of Our Fathers? have a peek here 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?

I'm desparate today!!!! 0 Comment Question by:tparrett Facebook Twitter LinkedIn https://www.experts-exchange.com/questions/27475310/Suppress-A-Blank-Line-in-Mail-Merge-Word-2010.htmlcopy LVL 76 Active 1 day ago Best Solution byGrahamSkan That tells us not to pursue that route. if the field is blank you will automatically have no spaces. 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 The solutions I posted are for Word, not Publisher.

That's it!  You should be able to now perform the mail merge to screen or printer and see the desired results. This is a Word forum, after all. I am trying to produce some labels based on Title, Forename, Surname, Department Company.