Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-11-2014, 05:53 PM
bufferemail bufferemail is offline Page Break on Key Change Windows 7 64bit Page Break on Key Change Office 2010 32bit
Novice
Page Break on Key Change
 
Join Date: May 2014
Posts: 4
bufferemail is on a distinguished road
Default Page Break on Key Change

I can't make sense of the syntax for IF fields and I've gotten to the point where the bulk of my output is correct but nothing happens when a key value changes between lines.

{QUOTE{IF{MERGESEQ}=1 "{SET Key1 ""}{SET Key2 ""}"}"IF{IF{={IF{MERGEFIELD ED}= {REF Key2} 1 0}*{IF{MERGEDFILED NUM}={REF Key1} 1 0}}=0"{IF{MERGESEQ}>1 ""}{MERGEDFIELD NUM}{SET Key1 {MERGEFIELD NUM}}"}{IF{MERGEFILED ED}<>{REF Key2} "{SET Key2 {MERGEFIELD ED}}"}{MERGEFIELD LAST}, {MERGEFIELD FIRST}"}


The data source is sorted first by ED, then by NUM.

I'd like the output to be like this so that when the entries with like EDs end and a new ED starts it would insert a page break, then the new ED value, then another page break.

--page break--
ED1
--page break--


NUM1
Last, First
Last, First

NUM2
Last, First

--pagebreak--
ED2
--pagebreak--
NUM3
Last, First
Last, First


Is my structure correct and if so where would I place the page break so that it appears when the ED changes?

Thank you in advance!
Reply With Quote
 

Tags
key, mail merge, page break



Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Break on Key Change Delete a page after Section Break Next Page Aston Word 9 04-27-2022 07:38 AM
Page Break on Key Change First section will not 'insert' blank page even though sectn 2 is 'odd' page break Pat_Hodgson Word 6 12-01-2013 04:22 PM
Page Break on Key Change Section break makes style change when printing or saving as pdf bohk Word 4 06-07-2013 02:34 PM
Page Break on Key Change Section Break (Next Page) replaces Section Break (Continuous) when deleted Carlabasson Word 2 03-25-2013 10:13 PM
paragaph hard break, soft break and ...strange break czomberzdaniela Word 2 12-03-2010 06:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft