Ask Your Question

labels with incremental numbers

asked 2016-08-19 19:10:16 +0200

Spikey1973 gravatar image

updated 2016-08-20 03:31:08 +0200

i need to print labels with nothing more then an incremental number on it from 1 to 1499 how can i do this automatically so without having to type the numbers.

does anybody have any idea how i can do this? any help would be very much appreciated!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-08-20 07:28:22 +0200

pierre-yves samyn gravatar image


You can use the Mail Merge technique. See my answer in this post.

You have to adapt:

  • numbers (Fill Cells is in Sheet menu since 5.2)
  • create synchronized labels: insert the SN field in the first label
  • InsertFieldMore fieldsDatabase tab▸Next Record at the end of the first label then click Synchronize Labels button


edit flag offensive delete link more


thanks for your answer.. i will need to try this out somewhere after coming wednesday but seems to be exactly what i need. if any questions i will come back on this

Spikey1973 gravatar imageSpikey1973 ( 2016-08-20 19:57:53 +0200 )edit

apparently i have still 5.1, so i mainly looked at your previous post. but i'm doing something wrong. at the end. (always so much more frustrating) I made the spreadsheet i opened a page with labels i added the database spreadsheet. tried to add the <sn> in the header, or the first field or all fields or the page's header but i can't seem to get it to fill up with the numbers.

made a screenshot of it but i don't seem to be able to post it here. :( sorry for my stupidity...

Spikey1973 gravatar imageSpikey1973 ( 2016-08-21 05:25:23 +0200 )edit

As I said you have to adapt: in your case, you have to insert the field in the first label, not in the header.

pierre-yves samyn gravatar imagepierre-yves samyn ( 2016-08-21 06:42:20 +0200 )edit

i understand, but wasn't sure as you mention 5.2 and i only have 5.1 (ubuntu) i also tried the help on synchronized labels but on the tutorial i got hung up on section 4.

  1. On the Options tab page, make sure that the Synchronize contents box is selected. (done) If this is selected, a label only has to be entered (on the top left label) and edited once. (this part i don't get and where i gets wrong. )

under distribute in the options tab: entire page (or single label, but i believe not)

Spikey1973 gravatar imageSpikey1973 ( 2016-08-21 16:20:09 +0200 )edit

there select synchronize content.

but then there is the comment:"a label only has to be entered (on the top left label) and edited once".

when i synchronize i get an entire page full with "<sn>, enter, a space". which i believe to be correct.

but how do i "enter a label" and how do i "edit" it? i do get the idea of the synchronize labels button, but i just cant get the right synchronization out of it.

Spikey1973 gravatar imageSpikey1973 ( 2016-08-21 16:29:01 +0200 )edit

i kinda got it sorted via mail merge wizard. not ideally but good enough.

Spikey1973 gravatar imageSpikey1973 ( 2016-08-22 17:24:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-19 19:10:16 +0200

Seen: 640 times

Last updated: Aug 20 '16