Microsoft Office Forums I am getting blank lines with Mail Merge

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2018, 11:42 AM
rtcary rtcary is offline I am getting blank lines with Mail Merge Windows 10 I am getting blank lines with Mail Merge Office 2010 64bit
Novice
I am getting blank lines with Mail Merge
 
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 online now I am getting blank lines with Mail Merge Windows 7 64bit I am getting blank lines with Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,482
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
I am getting blank lines with Mail Merge Mail merge envelopes are blank when printed DIYman Mail Merge 1 03-07-2017 02:30 PM
I am getting blank lines with Mail Merge Eliminating blank lines in mail merge (labels) BeerStud Mail Merge 1 11-28-2014 06:29 PM
I am getting blank lines with Mail Merge 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
I am getting blank lines with Mail Merge 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 04:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft