Ask Your Question
0

How do I find/create a template for a new Avery label that isn't in Writer?

asked 2017-11-28 03:17:28 +0200

HughMungus gravatar image

I bought some Avery labels yesterday that I'd like to try printing on. I guess they're new because they aren't listed in the drop down for Avery labels in Writer. They are Avery 6468 labels. There are 2 columns of 5 labels each and the labels are 2" x 4".

Is there some place to go to find a template for that label that will work in Libre Office? If so, where do I look for these? Or do I need to create it myself? In that case, how do I do that?

edit retag flag offensive close merge delete

5 Answers

Sort by » oldest newest most voted
0

answered 2018-09-07 01:10:32 +0200

updated 2018-09-07 04:45:24 +0200

The thorough initial answer and other comments have prob. answered my problem. I'll report back if this doesn't fix it. [Added later:] Well… sort of. Following the suggestion above about the Labels option [can't give details of who, as I can't re-view the Q&A w/o closing this!] I got a lot further than expected before hitting a wall. I'm trying to print a whole sheet of individual labels (in a single format but with different data on each — not, youda thought, the first time anyone's ever tried!) But can I find a way to switch away from printing one whole page of identical labels? It's not a viable solution to print 15 redundant copies of every label to get the one I want: that's about half a ream of copy-paper, for something needing about 10 sheets. The step beyond where I am now can't be complicated, but LO's dialogs and somewhat jargon-ridden descriptions aren't intuitive and haven't proved enlightening. Can someone else be? Thanks

edit flag offensive delete link more
0

answered 2017-12-03 15:14:09 +0200

Grantler gravatar image

updated 2017-12-03 15:19:44 +0200

Then, I created a table

If you want to synchronize your labels the inserting of frames is the better way of proceeding (Office can help you by menu File > New > Labels).

Nevertheless it is possible to insert sections in table cells, but not so effortless...

If you start with menu File > New > Labels the page size and customizing (margins) are to be done just after having designed the frames and put them into a new page...

See my sample file (which was designed on OpenOffice; the frames are anchored As Character which is more useful for later customizing the page properties). In that case I applied as page size Letter and as page margins (left/upper) 0.25 inches. - Download sample file here: ( C:\fakepath\Label2x4inches_2x5specimen.odt ) - It all was a work of around 5 minutes.

Cheers

LibreOffice's Label Assistant anchors the frames To Page which cumbers later page customizing...

edit flag offensive delete link more
0

answered 2017-12-02 17:00:14 +0200

Lady Fitzgerald gravatar image

Avery's templates for Word will work fine in LO. I use several of them.

Occasionally, a blank page will be added at the beginning of the template when first opened in LO. I just delete that page, then save the template as a LO template. No more problems.

edit flag offensive delete link more
0

answered 2017-12-02 11:47:11 +0200

peterwt gravatar image

updated 2018-09-07 16:34:10 +0200

You can create a custom label in LO. File > New > Labels and select the Labels Tab. Select the Brand - "Avery Letter Size" or "Avery A4". I think 6468 it a US Label so will be Letter Size. Select Type [user]. Select the Format Tab and enter the dimensions and Save. This label will then be available to create labels in future. If you want to create a Template for these labels click New Document and save as a Template. You can also then use the new label design in mail merge.

EDITED 7/9/18

As @Lady Fitzgerald said you can use Avery Word Templates in LO. if you want to have different text on each Label entered manually then this is the best way.

If you create a new Label as I described previously, you can use a Database or spreadsheet as the data source.

I have attached a template for the US 6468 Label. C:\fakepath\Avery6468RemovableIDLabels.odt

edit flag offensive delete link more
0

answered 2017-12-02 05:24:07 +0200

HughMungus gravatar image

No one has answered my question I did a bit of research and figured out how to create my own template. For the sake of those who come along later, I am describing what I did so that others will have a head start.

First of all, I have no idea if anyone on the development team for Libre Office is generating templates for new labels as they are released to the market. There are a lot of templates for commercially-available labels already in the program so someone must have done the work to create them but I don't know if new labels are systematically added to Libre Office. Perhaps the labels I have are so new that they simply haven't had a template developed yet and the developers will add them to the product soon. Or maybe they only get created if there is a significant demand for a given label. I leave that for others to determine.

Also, I should mention that the label companies - or at least Avery, which is the only one I checked - do have templates on their website but they are for Word, not Libre Office. I have no idea if a Word template will work in Libre Office and didn't try the Word template for my new labels.

Since I had no template and wanted one, I thought about creating my own, although I had no real idea how to proceed. I looked at the Writer Guide to get the basic concept that I needed. Although the Writer Guide is a bit dated now since it is targeted at Writer 4.2 and I am running 5.4.2.2, the Writer Guide still seems accurate on the subject of templates, at least to the limited extent I looked at that chapter. The Writer Guide made it clear that I could simply develop my own document and then save it as a template and put it in the "My Templates" area. That was the key concept I needed.

I created my document quite simply. I began by finding a ruler and removing one of the label sheets from the package. I measured the following things: the size of the label sheet, the margins (top, bottom, left and right), the height and width of the labels, and the width of the space between columns of labels (I think these are called gutters). I also counted the number of labels in a column and the number of columns on the sheet. Then I created a new document. I formatted the page first by clicking on Formats->Page... then chose the Page tab. I chose the proper page size and orientation (which is normally portrait for label sheets). I set the top, left, right and bottom margins, then closed the Page properties.

My labels, for the Avery 6468 labels, are in 2 columns of 5 rows each. I determined that there was no obvious way to leave space between the columns of a table ... (more)

edit flag offensive delete link more

Comments

see answer

Grantler gravatar imageGrantler ( 2017-12-03 14:53:20 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-28 03:17:28 +0200

Seen: 3,139 times

Last updated: Sep 07 '18