Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2018, 06:00 PM
dducic dducic is offline Can I "repeat" a Next Record on the same page? Windows 10 Can I "repeat" a Next Record on the same page? Office 2013
Novice
Can I "repeat" a Next Record on the same page?
 
Join Date: Sep 2018
Posts: 3
dducic is on a distinguished road
Default Can I "repeat" a Next Record on the same page?

Hi everyone,



I'm new to the forum and have a question regarding how to "repeat" a Next Record on the same page. In a nutshell, I'm creating badge IDs for an upcoming conference using Avery 8522 labels, which have two columns per page containing a main badge and two secondary badges. I want to use one of the secondary badges as a raffle ticket with the attendee's name/company on it, so it needs to match the name/company of the main badge directly above it. Unfortunately, I'm having a problem using <<Next Record>> more than once on the same page. Before diving into too many words, I've attached a diagram of my problem below, which should help effectively communicate my problem. Your assistance is greatly appreciated!

~David

Reply With Quote
  #2  
Old 09-20-2018, 08:16 PM
macropod's Avatar
macropod macropod is offline Can I &quot;repeat&quot; a Next Record on the same page? Windows 7 64bit Can I &quot;repeat&quot; a Next Record on the same page? Office 2010 32bit
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

I can find no record of an Avery 8522 label on the Avery website, so it's a bit hard to know how many labels to a page there are, If it's a multiple of three, you could do a set-up for a standard label merge (which includes propagating all the labels via the 'Update labels' button), then delete the «Next Record» field from every 2nd & 3rd label, working in an across-then-down order. Otherwise, you could do the setup for the labels in the normal manner, then either:
• execute the merge 3 time; or
• save two versions of the mailmerge main document: one with all the «Next Record» fields in place (e.g. for the tickets); the other with all the «Next Record» fields in the second column deleted (e.g. for the main badge and one secondary badge), an execute two merges, one from each mailmerge main document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-20-2018, 09:02 PM
dducic dducic is offline Can I &quot;repeat&quot; a Next Record on the same page? Windows 10 Can I &quot;repeat&quot; a Next Record on the same page? Office 2013
Novice
Can I &quot;repeat&quot; a Next Record on the same page?
 
Join Date: Sep 2018
Posts: 3
dducic is on a distinguished road
Default

Hi Paul,

Thanks for your reply. Avery 8522 (https://www.avery.com/products/namebadges/8522) has two labels per page, along with the two secondary labels each below them. Based on the fact it has two labels, how would you proceed?
Reply With Quote
  #4  
Old 09-20-2018, 11:06 PM
macropod's Avatar
macropod macropod is offline Can I &quot;repeat&quot; a Next Record on the same page? Windows 7 64bit Can I &quot;repeat&quot; a Next Record on the same page? Office 2010 32bit
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

Hmm, not listed on the Avery Aus site. The link you posted says the 8522 format has "2 Name Tag Inserts and 4 Tickets per Sheet". What it doesn't show, though, is the layout, which is what I'd need before advising further. Can you attach a document to a post with the labels in the 8522 format?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 09-20-2018, 11:14 PM
dducic dducic is offline Can I &quot;repeat&quot; a Next Record on the same page? Windows 10 Can I &quot;repeat&quot; a Next Record on the same page? Office 2013
Novice
Can I &quot;repeat&quot; a Next Record on the same page?
 
Join Date: Sep 2018
Posts: 3
dducic is on a distinguished road
Default

Paul, this template page on Avery.com shows an outline of the layout - does this help? https://www.avery.com/templates/8522

My design layout has the large two badges at the top and the smaller two badges underneath them. The bottom portion of the template (the bottom two rectangles) are scrap.
Reply With Quote
  #6  
Old 09-21-2018, 04:15 PM
macropod's Avatar
macropod macropod is offline Can I &quot;repeat&quot; a Next Record on the same page? Windows 7 64bit Can I &quot;repeat&quot; a Next Record on the same page? Office 2010 32bit
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

I do need an actual document, so I can test how that setup works with mailmerge in Word.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I &quot;repeat&quot; a Next Record on the same page? Microsoft Word and Excel 2010 Mail Merge importing contacts as "Next Record" Kendel6 Mail Merge 1 10-06-2017 01:39 PM
Can I &quot;repeat&quot; a Next Record on the same page? Update Fields reverts all labels to "Next Record" bsn321 Mail Merge 3 12-09-2016 05:21 AM
Can I &quot;repeat&quot; a Next Record on the same page? Showing "page of numpages" and "sectionpage of sectionpages" RobH Word 2 02-14-2016 04:12 PM
Can I &quot;repeat&quot; a Next Record on the same page? Problem with "Next page" section break automatically turning into "Odd or Even Page" c_gallagher25 Word 1 02-12-2014 04:27 PM
When composing an e-mail how do I add "Page Layout" and "View" tabs to the ribbon CensorTilSin Outlook 1 12-11-2013 12:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 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