Mailmerge spacing and blanks!?

stumac · #1 11-29-2018, 02:14 AM

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) "")

macropod · #2 11-29-2018, 09:51 PM

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

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