Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2018, 02:14 AM
stumac stumac is offline Mailmerge spacing and blanks!? Windows 10 Mailmerge spacing and blanks!? Office 2016
Novice
Mailmerge spacing and blanks!?
 
Join Date: Nov 2018
Posts: 1
stumac is on a distinguished road
Default Mailmerge spacing and blanks!?

Im trying to develop a bespoke letter for a few hundred organisations based on information they have already given us in 17 thematic areas.



I have developed a mail merge which does what I need, but I'm confused on how to code in spaces and suppress blanks...

At the moment I have inserted spaces between lines, which gives me the spacing I want between sections, but the code is leaving a blank where the condition is not met and so I end up with lots of blank space in my output letter...

How do I code in spaces and suppress blank lines and spaces if no result is found...



Code:
(IF(MERGEFIELD M_1)<>"" "(MERGEFIELD M_1_B_Q) "")

(IF(MERGEFIELD M_2)<>"" "(MERGEFIELD M_2_B_Q) "")

(IF(MERGEFIELD M_3)<>"" "(MERGEFIELD M_3_B_Q) "")
Reply With Quote
  #2  
Old 11-29-2018, 09:51 PM
macropod's Avatar
macropod macropod is offline Mailmerge spacing and blanks!? Windows 7 64bit Mailmerge spacing and blanks!? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See Mailmerge Empty Line Suppression in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge spacing and blanks!? if/then/else and blanks jmunro10 Mail Merge 5 02-06-2017 05:03 PM
Mailmerge spacing and blanks!? Counting Blanks in 1 Column and Non-Blanks in Another dogwood705 Excel 4 02-07-2015 08:45 AM
Mailmerge spacing and blanks!? Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 8 02-11-2013 04:40 AM
Mailmerge spacing and blanks!? Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM
Mailmerge spacing and blanks!? fill blanks in box keevitaja Word 1 05-23-2011 06:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:42 AM.


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