Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-21-2022, 06:11 AM
ssamuelson ssamuelson is offline Insert a page break into a mail merge if the field changes Windows 10 Insert a page break into a mail merge if the field changes Office 2019
Novice
Insert a page break into a mail merge if the field changes
 
Join Date: Sep 2022
Posts: 2
ssamuelson is on a distinguished road
Default Insert a page break into a mail merge if the field changes


I am using Microsoft Word 2019 and have a labels mail merge file with address, name and class fields - this is sorted in class order. I would like each class to appear on a separate sheet of labels so when the class field changes I would like to insert a page break.

Can anyone assist.
Thanks
Reply With Quote
  #2  
Old 09-21-2022, 07:20 AM
macropod's Avatar
macropod macropod is offline Insert a page break into a mail merge if the field changes Windows 10 Insert a page break into a mail merge if the field changes Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Page breaks can't be inserted into label merges. What you could do is:
1. Delete all labels except the first;
2. Format the page with a multi-column layout, using however many columns your stationery has, plus the same inter-column spacing as the inter-label spacing on the label stationery;
3. Use a directory merge instead of a label merge.
This will result in the mailmerge outputting what is essentially a single column of labels. Then, whenever there is a class change, you could insert a manual page break.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-21-2022, 08:00 AM
ssamuelson ssamuelson is offline Insert a page break into a mail merge if the field changes Windows 10 Insert a page break into a mail merge if the field changes Office 2019
Novice
Insert a page break into a mail merge if the field changes
 
Join Date: Sep 2022
Posts: 2
ssamuelson is on a distinguished road
Default

Thank you - I will try the suggestion.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Planet12345 Word 3 11-08-2021 03:48 PM
Insert a page break into a mail merge if the field changes Mail Merge Directory - Page Break Layout Wang Mail Merge 4 08-06-2020 06:16 PM
Insert a page break into a mail merge if the field changes Unable to insert line break or carriage return in mail merge field shahid.majeed Mail Merge 4 09-19-2019 01:08 AM
Insert a page break into a mail merge if the field changes Word converts section break to page break before columns, does not insert column breaks eborda Word 1 03-24-2017 11:06 PM
mail merge with 2/3 keys? cant get page break Lisa274 Mail Merge 5 01-06-2014 05:13 PM

Other Forums: Access Forums

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


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