Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2020, 01:25 PM
katword01 katword01 is offline Labels-number sequence not advancing to next pg Mac OS X Labels-number sequence not advancing to next pg Office 2019
Novice
Labels-number sequence not advancing to next pg
 
Join Date: Dec 2020
Posts: 1
katword01 is on a distinguished road
Default Labels-number sequence not advancing to next pg

I have a table with merged data from an excel file. The table is set up to print onto address labels for asset stickers. Each label includes 3 table cells...2 columns x 2 rows with the top row merged for the "Property of" title. When previewing, the first page everything is great (except I would prefer the number sequence to go down the labels on the left and over to the labels on the right, but I'm satisfied the way it is).


The problem is when it carries to page 2, because the sequence is all off, with repeating numbers from the previous page. I will attach several of the previews as a reference.



I've never had this problem with mail merging before, except this project is different in that: 1) I needed to use multiple cells to offset the data from the item number - inserting a text box to do this didn't work, 2) I had to set the table up without using Word's traditional mail merge process, and 3) I am using a barcode font. The table formatting prints great on the labels, other than the number sequence issue.





Any help is GREATLY appreciated. I need to get this process down, because this is what we have to use for inventory.
Attached Images
File Type: jpg Labels-Excel.jpg (128.6 KB, 9 views)
File Type: jpg PreviewPg1-2.jpg (264.2 KB, 7 views)
Reply With Quote
  #2  
Old 12-12-2020, 09:27 PM
gmayor's Avatar
gmayor gmayor is offline Labels-number sequence not advancing to next pg Windows 10 Labels-number sequence not advancing to next pg Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Have you actually merged to a new document or are you simply previewing the merge document? Complete the merge to a new document and see how that works.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Employee number according to timetable sequence aligahk06 Excel 0 07-27-2019 07:56 AM
Formula for number sequence 14spar15 Excel Programming 4 03-18-2018 07:00 PM
Labels-number sequence not advancing to next pg Figure Captioning Labels All Figures As Number 1 AnonAccount Word 3 03-31-2015 10:44 PM
Labels-number sequence not advancing to next pg Need an excel formula to remove dashes in a number sequence jyfuller Excel Programming 3 02-27-2013 10:32 PM
Labels-number sequence not advancing to next pg Excel sheet Sequence Number belloffice Excel 1 02-25-2010 02:41 PM

Other Forums: Access Forums

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