Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
I managed to do it eventually!
I realised that it is of paramount importance to press Enter and not Shift+Enter to start a new line (¶), otherwise Word will always leave a gap between the two lines, even if your formula is correct. So this is the formula: { MERGEFIELD Company }¶ { MERGEFIELD Address_1 }{If { MERGEFIELD Address_1 } = "" "" " " }¶ { MERGEFIELD Address_2 }{If { MERGEFIELD Address_2 } = "" "" " " }¶ { MERGEFIELD Address_3 }{If { MERGEFIELD Address_3 } = "" "" " " }¶ { MERGEFIELD Address_4 }{If { MERGEFIELD Address_4 } = "" "" " " }¶ { MERGEFIELD Post Code } { MERGEFIELD Town }¶ { MERGEFIELD County }{If { MERGEFIELD County } = "" "" " " }¶ { MERGEFIELD County }¶ I found the right formula by reading this very useful guide: https://wordmvp.com/FAQs/MailMerge/MMergeIfFields.htm |
#2
|
|||
|
|||
Quote:
I too had same problem. Thanks for this valuable information. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Empty page after column break | Page Layout | |||
Need Macro to remove empty paragraph marks. | Microsoft Word Help | |||
using word 2007 suppress blank line when merge field is empty | Mailmerge | |||
In Word 2003 when mail merge how do I delete an empty field? | Mailmerge | |||
differentiate a line break from a paragraph break | Microsoft Word Help |