![]() |
|
#1
|
|||
|
|||
![]()
Hi - looking for some advice to prevent baldness as I'm tearing my hair out with this issue!
I've got a complex mail merge with nested IFs but have simplified below to provide an example as I can't work out where to put the /b "" & the paragraph marker from the line above text text text { if {MERGEFIELD BONUS_SCHEME } = "Regional" "{ MERGEFIELD Regionname }% Region" } text text text If the BONUS_SCHEME merge field doesn't contain 'Regional" then this is what I see text text text text text text so I want to remove the blank line - but for the life of me I can't work out where to put the switch - can anyone help please?! |
#2
|
||||
|
||||
![]()
Simple:
text text text{IF{MERGEFIELD BONUS_SCHEME}= "Regional" "¶ {MERGEFIELD Regionname}% Region"}¶ text text text¶ where the ¶ characters represent real paragraph/line breaks.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
blummin' brilliant - thank you so much - and no need to use /b etc which is what I'd been trying to do based on lots of online posts.
Genius!! |
#4
|
||||
|
||||
![]()
The \b and \f switches are only useful for controlling whether to output something dependent in whether the parent field - in this case BONUS_SCHEME has data; they can't be used to differentiate data. See the Mailmerge Empty Line Suppression topic in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
![]()
yes, I can see now that makes absolute sense - and what a treasure trove of knowledge in the tips & tricks thread, wow!
thanks for your help, it's much appreciated |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jamu | Word VBA | 9 | 04-11-2022 04:21 PM |
![]() |
rgm60527 | Mail Merge | 2 | 02-22-2022 11:13 AM |
Opening Blank Doc while Off-Line | MurrayL | Word | 1 | 08-25-2019 01:32 AM |
Opening Blank Doc while Off-line | MurrayL | Word | 1 | 08-24-2019 11:31 PM |
syntax for inserting blank line before inserting table and after a line or paragraph | SamDsouza | Word VBA | 8 | 08-04-2019 11:10 PM |