Generate sequential numbers (preferably in thousands)

[Alberto5501]

Hi




I'm trying to generate at least a thousand labels for my lab.



I'd need them to begin in "T2119", then "T2120" and so on. After "T9999" it should be "U0001" and so on. But let's just focus on the "T" sequence.



I tried to use the SEQ field but I can't seem to make it work. My labels seem to be ancient too , so I had to download the template from Avery, it's number is 4014. Even then, they print weirdly.


Is there a way to achieve this? Or, do I need to do in another kind of software?


Thanks!!
Al

[macropod]

The simplest way would be to create an Excel workbook you can use as a mailmerge data source and configure your document for a label merge. The Excel workbook would have a heading in A1 (e.g. 'Label'), 20 in B1 and, in A2 & below, the formula:
=CHAR(INT((ROW()-2)/10000+B$1)+64)&TEXT(MOD(ROW()-2,10000),"0000")
This will start A2 at T0000. Copy the formula down to at least row 10001, to complete the 'T' series. You can continue copying down for the 'U' series, etc., if you want. Alternatively, once you've finished creating the 'T' series labels, you can change the 20 in B1 to 21, and so on.

Although the numbering series in Excel starts at T0000, you can tell the mailmerge to start from a different record. For example, to start at T2119, you'd tell the mailmerge to start from record 2120. For the mailmerge label basics, see: https://support.office.com/en-us/art...8-2e8dcf271252

[Guessed]

I would do it with Seq fields
First entry = T{Seq T \r 2119}
Thereafter = T{Seq T}

[gmayor]

See https://www.gmayor.com/Numbered_labels.htm and https://www.gmayor.com/NumberLabels.htm

[Alberto5501]

Thank you for all your responses. I managed to get the SEQ field to work at home, but couldn't replicate this at my office


Tried to run the add-on that gmayor suggested, but guess what? I get an error and I don't have admin privileges on this computer, so I didn't even tried to fix it.


The formula provided by macropod works like a charm.


Thank you for all your help!