Thread: [Solved] Mailmerge spacing and blanks!?
View Single Post
 
Old 11-29-2018, 02:14 AM
stumac stumac is offline Windows 10 Office 2016
Novice
  
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