Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2019, 10:25 AM
Rog Rog is offline Packing list tables Windows 10 Packing list tables Office 2019
Novice
Packing list tables
 
Join Date: Nov 2019
Posts: 1
Rog is on a distinguished road
Default Packing list tables

Mail merge

Hello

I have a table in excel that is a packing list of items. Let’s say an international carnet.

I want to do a mail merge to print out “reports” or “labels” that have multiple lines of the table on one label.

For a simple example

Item A - crate 1
Item B - crate 1
Item c - crate 2


Item d - crate 2


So the crate 1 label would have “Crate 1” on the top and below that a table or just list of what has “crate 1” in the column. This could be 100 items, and 200 crates.

I’m not a coder. I see that “directory” may be a good option, but I’m trying to figure out hours to tell it that I only want things with the same crate number to be on one label then go to the next label.

To expand on this, can it make a table that auto formats to include one row per value? Then if there was one value, there would be one row, but if 20 items, 20 rows.

Thanks.
Reply With Quote
  #2  
Old 11-08-2019, 12:19 AM
gmayor's Avatar
gmayor gmayor is offline Packing list tables Windows 10 Packing list tables 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

It rather depends on what you mean by a 'label' in this context. I cannot imagine a 'label' that would contain a hundred items. A packing 'document' however is less of an issue. You could use Merge Many To One to create such a report/list with one crate per document, but it won't create multiple 'labels' of crates per page. That would require a custom process.
__________________
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
How to insert a list of figures and a seperate list of tables? msword_matt Word 0 01-20-2019 02:47 PM
Packing list tables dropdown list to create tables brichigo Word VBA 8 09-04-2018 02:36 AM
Packing list tables How can I build figures list and tables list separately lopesdasilva Word 2 05-31-2016 01:30 AM
Packing list tables Modifying List of Tables caleno Word Tables 2 11-04-2011 08:06 AM
Packing list tables Hopefully you can help RE List of Tables W7PSK Word 6 06-17-2011 06:55 AM

Other Forums: Access Forums

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