Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
So considering that I am on a Mac and those commands as far as I know do not work here, but I will try tomorrow from a Windows, to achieve the following without paragraph breaks if the field is empty:
Company Address_1 Address_2 Address_3 Town Post Code County Country Is the following correct? { Mergefield Company }¶ { Mergefield Address_1 }{If { Mergefield Address_2 } "" " ¶ { Mergefield Address_2 }"}{If { Mergefield Address_3 } "" " ¶ { Mergefield Address_3 }"}¶ { Town } { Post Code }¶ {If { County } "" " ¶ { Mergefield County }"}¶ {Country} Please note that ¶ is where I pressed Enter or Shift + Enter. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |