Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-20-2018, 11:42 AM
rtcary rtcary is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Feb 2017
Posts: 6
rtcary is on a distinguished road
Default I am getting blank lines with Mail Merge

The condition that if the field contains two dashes ("--") do not print anything is working, however it leaves an empty/blank line. I'm missing some little item in the syntax.



{IF{MERGEFIELD Bus_Address_2}<> "--" "{MERGEFIELD Bus_Address_2}"}

Thank you for any suggestions. I read the very detailed document in the Sticky section, however it does not appear to cover this situation.

\rtc
Reply With Quote
  #2  
Old 01-20-2018, 02:07 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,191
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

That's because you've left the paragraph break/line break that's creating the empty line outside the IF field. Instead of being constructed thus:
{IF{MERGEFIELD Bus_Address_2}<> "--" "{MERGEFIELD Bus_Address_2}"}

tt should be constructed thus:
{IF{MERGEFIELD Bus_Address_2}<> "--" "{MERGEFIELD Bus_Address_2}
"}
Scenarios like this are actually dealt with in the Mailmerge Tips & Tricks thread, in the note under Mailmerge Empty Line Suppression
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge envelopes are blank when printed DIYman Mail Merge 1 03-07-2017 02:30 PM
Eliminating blank lines in mail merge (labels) BeerStud Mail Merge 1 11-28-2014 06:29 PM
Getting blank lines instead of supressed lines. Welshie82 Mail Merge 2 11-14-2011 01:41 AM
delete blank pages from mail merge document blusea Word 0 12-17-2010 06:10 PM
How to turn all blank lines into non-blank for legal forms sieler Word 3 04-12-2009 01:38 PM


All times are GMT -7. The time now is 01:41 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft