#1
|
|||
|
|||
Adding sequential number to labels beside non sequential data
I have ton of folders need to be labeled, each folder differently have its proper DATA (text and numbers), which need to be typed one by one.
I need to add sequential numbers beside or under that each DATA on each single label. The fact I was able do it by creating excel file and applied it to my Word file. But the problem when I update (Update Labels), each of the DATA got replaced by the first DATA of the first label. Any effort would be appreciated. Tanks Millwood. |
#2
|
||||
|
||||
If your data and the numbers are in an Excel data file, you could simply merge the numbers and associated data to labels - Mail Merge Labels
If you just want numbers on labels - see Numbered Labels
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thanks for the answer,
I just typed the DATA and the sequential numbers in excel, so the DATA also comes with 3 inputs in 2 rows (a text+ serial numbers and code numbers),the third row for the sequential numbers, when run the in excel (Ctrl+Drag the fill handle), it only duplicates it (third row). it might because many numbers in a same cell (serial num, code num and sequent num.). |
#4
|
|||
|
|||
To do a basic mail merge, you need everything variable for a single label to be in one row. In mailmerge terms, each row is a separate record.
These must be big labels. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Looking for help with creating sequential serial number on one page | 4ener | Word | 9 | 02-24-2019 07:50 AM |
sequential number and macro | optima | Word | 6 | 05-15-2018 11:01 PM |
I would like a function to add sequential numbers to a class number/name | Highlander01 | Excel | 5 | 01-22-2016 02:29 PM |
Adding sequential Number in a document that already has merged fields inserted | Highlander01 | Mail Merge | 3 | 01-19-2016 12:33 PM |
Labeling sequential forms with a unique number | krau0231 | Word | 1 | 10-18-2012 03:33 PM |