Thread: and if statement in word mailmerge
View Single Post
 
Old 08-22-2017, 02:39 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
I suspect the underlying issue is that {MERGEFIELD RunTotal} never outputs "Continued", because the mailmerge process treats the entire column as numeric and anything text is output as 0. You should be able to test that. If I am correct about what's happening and if your data don't include and true 0s or blanks, you could re-code the field as:
{IF{MERGEFIELD RunTotal}= 0 {IF{=MOD({PAGE},2)}= 0 "{QUOTE 12}Intentionally blank page"}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote