View Single Post
 
Old 08-21-2017, 08:51 AM
sbye sbye is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2017
Posts: 9
sbye is on a distinguished road
Default and if statement in word mailmerge

Hi,
I am trying to get the mailmerge to look at a mailmerge field and if it displays the words "Continued" I want it to take no action, but if it does not display "Continued" and the page number is an even number I want it to insert a page break.

The code below inserts a blank page on every page unless it displays "Continued" which isn't quite correct.

{if {MERGEFIELD RunTotal \####,###,##0.00}="Continued" { IF{ =MOD({ PAGE \*Arabic },2)}=0 }"[page break]Intentionally blank page" " " }

Any help would be very much appreciated.

Thanks, Stephen.
Reply With Quote