Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2012, 06:44 PM
TimK9VB TimK9VB is offline Detecting Page Breaks in Mail Merge Directory Windows XP Detecting Page Breaks in Mail Merge Directory Office 2010 32bit
Novice
Detecting Page Breaks in Mail Merge Directory
 
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
  #2  
Old 04-23-2012, 07:23 PM
Charles Kenyon Charles Kenyon is offline Detecting Page Breaks in Mail Merge Directory Windows Vista Detecting Page Breaks in Mail Merge Directory Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Consider adding page break before formatting to your composer heading. Then use a StyleRef field in a header to display this at the top of the page.
Reply With Quote
  #3  
Old 04-23-2012, 08:43 PM
TimK9VB TimK9VB is offline Detecting Page Breaks in Mail Merge Directory Windows XP Detecting Page Breaks in Mail Merge Directory Office 2010 32bit
Novice
Detecting Page Breaks in Mail Merge Directory
 
Join Date: Apr 2012
Posts: 3
TimK9VB is on a distinguished road
Default

Thanks, Charles but I don't think that will do what I want. I don't want to always start each composer on a new page, I just want to put in a reminder header when the entries for one composer roll over to a new page.
Reply With Quote
  #4  
Old 11-20-2012, 07:28 AM
moemax moemax is offline Detecting Page Breaks in Mail Merge Directory Windows 7 64bit Detecting Page Breaks in Mail Merge Directory Office 2007
Novice
 
Join Date: Nov 2012
Posts: 2
moemax is on a distinguished road
Default

Hi Tim, Did you find a solution to this problem ?

Cheers
Reply With Quote
  #5  
Old 11-20-2012, 07:31 AM
TimK9VB TimK9VB is offline Detecting Page Breaks in Mail Merge Directory Windows XP Detecting Page Breaks in Mail Merge Directory Office 2010 32bit
Novice
Detecting Page Breaks in Mail Merge Directory
 
Join Date: Apr 2012
Posts: 3
TimK9VB is on a distinguished road
Default

Hi moemax

No I did not find a solution to this problem although I still keep trying things, nothing seems to work.

Regards
Tim
Reply With Quote
  #6  
Old 11-20-2012, 07:41 AM
moemax moemax is offline Detecting Page Breaks in Mail Merge Directory Windows 7 64bit Detecting Page Breaks in Mail Merge Directory Office 2007
Novice
 
Join Date: Nov 2012
Posts: 2
moemax is on a distinguished road
Default

Thanks for your quick response ....
Reply With Quote
  #7  
Old 11-20-2012, 01:52 PM
macropod's Avatar
macropod macropod is offline Detecting Page Breaks in Mail Merge Directory Windows 7 64bit Detecting Page Breaks in Mail Merge Directory Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

The StyleRef field will do as the OP wants, though not with the '(Continued)' annotation. Simply apply a specific Style to the mergefield containing the composer name, and insert a StyleRef field referencing that Style into the header.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Directory Mail Merge with table layout 3N1GM4 Mail Merge 11 06-03-2014 09:54 PM
Detecting Page Breaks in Mail Merge Directory mail merge multiple recipients per page bmobrien Mail Merge 3 02-23-2012 10:47 PM
Text preceeding a directory merge entercomp Mail Merge 0 02-13-2010 08:28 PM
Deleted Section Breaks Changes Page Breaks Brantnshellie Word 0 02-01-2009 09:22 PM
Paragraph Breaks In Mail Merge Fields SamuelT Mail Merge 0 09-25-2008 06:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:35 PM.


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