+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, (Conditional?) Pagebreak in Word (2010) from Excel (2010) Source in Technical; Hi, I want to insert a pagebreak in a mailmerge. I am trying to print out class lists, and can ...
  1. #1

    Join Date
    Jun 2008
    Location
    Stockport
    Posts
    14
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    (Conditional?) Pagebreak in Word (2010) from Excel (2010) Source

    Hi, I want to insert a pagebreak in a mailmerge.

    I am trying to print out class lists, and can do it if I manually filter the classes one at a time, but it's very slow. I'd just like to be able to fire-and-forget.

    mailmerge.JPG

    You can see from the embedded image, that the class name changes. At the point where it changes, I want to be able to insert, or force, an automatic pagebreak.

    For the life of me, I have not been able to find a way of doing this.

    Any suggestions?

  2. #2

    AngryTechnician's Avatar
    Join Date
    Oct 2008
    Posts
    3,730
    Thank Post
    698
    Thanked 1,212 Times in 761 Posts
    Rep Power
    394
    I had a similar problem recently and I couldn't find a way to do it either. I ended up importing the data into Access and building a report instead, which does allow you to group on particular fields and have a page break between them.

  3. Thanks to AngryTechnician from:

    HughR (16th September 2011)

  4. #3

    Join Date
    Jun 2008
    Location
    Stockport
    Posts
    14
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for that, I was hoping to avoid Access having had my fill of it in an HND. I suppose it makes sense though - I'll have to bite the bullet, it'll pay off in terms of time-saving in the long-run I suppose.

  5. #4

    AngryTechnician's Avatar
    Join Date
    Oct 2008
    Posts
    3,730
    Thank Post
    698
    Thanked 1,212 Times in 761 Posts
    Rep Power
    394
    My sentiments were the same, but sometimes needs must!

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 20th December 2011, 10:04 AM
  2. [MS Office - 2010] Saving in Word and Excel 2010
    By stebo730 in forum Office Software
    Replies: 15
    Last Post: 16th November 2011, 09:56 AM
  3. Replies: 4
    Last Post: 8th June 2011, 10:44 AM
  4. Replies: 0
    Last Post: 3rd May 2011, 08:23 PM
  5. Replies: 3
    Last Post: 8th April 2010, 10:08 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •