How to create a master label that repeats many times per page for printing sticker labels?

[papiertigre]

Hello,

I would like to create printing labels for my granola. So far, I worked with MS Word but it becomes to complex and Word is not made for this. Also for any small change, I need to manually change the 20 labels per DIN A4 page.

That is why I would like to switch to Affinity Publisher for the labels.

I need a little starting help: How do I create a Master label where I can define the graphic elements and text boxes so that every change on the master label is synced with the  20 labels on the printing page? 

I just need a little hint on how to get started. Any ideas?

Thanks in advance!

[Hangman]

Hi @papiertigre and welcome to the forums,

One approach you could try is to use the Data Merge Layout Tool in Publisher...

With the tool selected drag out a rectangle to match the dimensions of all 20 labels based on two across x ten deep setting the Columns to 2 and the Rows to 10 in the context toolbar.

Anything added in the top left cell, text frames, graphics etc., will be repeated in the remaining 19 cells.

When it comes to making changes to all 20 labels you simply edit the content of the top left cell and these changes will be automatically reflected in the other 19 instances...

Let us know if that works for you...

[Old Bruce]

Welcome to the forums papiertigre,

I think that is a great handle you have chosen.

27 minutes ago, papiertigre said:

I need a little starting help: How do I create a Master label where I can define the graphic elements and text boxes so that every change on the master label is synced with the  20 labels on the printing page? 

Affinity Publisher on its own cannot use Symbols which would solve this problem. If you own Designer and Publisher then it is quite simple. If you own Publisher only then it becomes more complex, using Publisher's Data Merge would solve it if you have access to a Spread Sheet application that can output .CSV or .XLSX.

Do you have access to Publisher and or Designer?

[walt.farrell]

7 minutes ago, Old Bruce said:

If you own Publisher only then it becomes more complex, using Publisher's Data Merge would solve it if you have access to a Spread Sheet application that can output .CSV or .XLSX.

As mentioned by @Hangman, for the simple case of fixed-content labels, you shouldn't need a spreadsheet.

[David in Яuislip]

Make the document the same size as the label, use N-Up in the print dialog, adjust gaps and margins to suit

[papiertigre]

Thanks for all the creative ideas and answers. I will check them out in detail.

To answer the question:

2 hours ago, Old Bruce said:

Welcome to the forums papiertigre,

I think that is a great handle you have chosen.

Affinity Publisher on its own cannot use Symbols which would solve this problem. If you own Designer and Publisher then it is quite simple. If you own Publisher only then it becomes more complex, using Publisher's Data Merge would solve it if you have access to a Spread Sheet application that can output .CSV or .XLSX.

Do you have access to Publisher and or Designer?

I got access to Publisher and Designer. What is your idea then?

 

@David in Яuislip, thanks for your idea, that sounds pretty straight forward and easy. If that works out as easy as it sounds, I think it will be the way to go.

 

Thanks again for all your speedy answers! Have a nice day!

[Old Bruce]

Make a Symbol for your label, then use that Symbol 20 times on your page. When it is time to change some information on the label you just need to change one symbol on the Master Page and all the pages will update.

Untitled.afpub

Untitled.afpub

[JessaM507]

On 4/3/2024 at 1:00 PM, David in Яuislip said:

Make the document the same size as the label, use N-Up in the print dialog, adjust gaps and margins to suit

thank you - you have helped me to finally be able to use this program the way I need to after years of using MS Publisher.