Microsoft Office Forums Packing list tables

Go Back   Microsoft Office Forums > >

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

Mail merge


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.

Reply With Quote
Old 11-08-2019, 12:19 AM
gmayor's Avatar
gmayor gmayor is offline Packing list tables Windows 10 Packing list tables Office 2016
Join Date: Aug 2014
Posts: 3,025
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice

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
Reply With Quote

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

All times are GMT -7. The time now is 09:56 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd. is not affiliated with Microsoft