View Single Post
 
Old 04-23-2012, 06:44 PM
TimK9VB TimK9VB is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Apr 2012
Posts: 3
TimK9VB is on a distinguished road
Default Detecting Page Breaks in Mail Merge Directory

I am using Word Mail Merge in Office 2010 to produce a report from an Excel Source. The source spreadsheet contains a list of pieces of music with columns for Composer, Work and Performer plus other stuff.

I print Composer as a heading and then list all works by that composer. This works fine but I would like to repeat the composer at the top of a page when the entries for one composer run over to another page. I do not want to start each composer on a new page but display something like 'Beethoven (Continued)' at the top of a page when necessary.

I'm happy with the conditional statement I need to set up but how do I detect new page? The only variable that I have found is {Page} which I thought I could monitor but it does not seem to get updated. If I print {Page} with each record as a test it always shows '2'. I have a front page which gets printed when MERGESEQ = 1 so I guess that is why {Page} starts at two but why doesn't it increment?)

Any ideas how I can check for new page?

Thanks
Tim
Reply With Quote