#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
|
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 |
dropdown list to create tables | brichigo | Word VBA | 8 | 09-04-2018 02:36 AM |
How can I build figures list and tables list separately | lopesdasilva | Word | 2 | 05-31-2016 01:30 AM |
Modifying List of Tables | caleno | Word Tables | 2 | 11-04-2011 08:06 AM |
Hopefully you can help RE List of Tables | W7PSK | Word | 6 | 06-17-2011 06:55 AM |