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 ...
15th September 2011, 05:16 PM #1
- Rep Power
(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.
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.
16th September 2011, 09:30 AM #2
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.
Thanks to AngryTechnician from:
HughR (16th September 2011)
16th September 2011, 10:01 AM #3
- Rep Power
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.
16th September 2011, 10:40 AM #4
My sentiments were the same, but sometimes needs must!
By ranj in forum Office Software
Last Post: 20th December 2011, 11:04 AM
By stebo730 in forum Office Software
Last Post: 16th November 2011, 10:56 AM
Last Post: 8th June 2011, 11:44 AM
Last Post: 3rd May 2011, 09:23 PM
By Ric_ in forum Office Software
Last Post: 8th April 2010, 11:08 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread