It's years later and I have Open Office 4. The instructions have not changed for this. Everything is the same!!!! Thank you for the easy follow along step by step on how to make my labels. I uses the free Avery label program but it's got SO many bugs in it that even free wasn't worth it. Thanks again.
I do find it amazing that my video is still helping so many after 7 years. OpenOffice has declined in popularity over recent years, and updates are rare. I still occasionally recommend it to customers, but don't use it much myself anymore. I'm glad that my video was able to help you. Thank you for the comment. :)
Ideal tutorial to set-up labels both singly or to produce sheet of multiple labels whether individual or page of the same label e.g. "FRAGILE" or "DO NOT BEND" Thanks for your time, well done.
Thank you sir. That was very informative. I am using Avery ink jet return address labels to type my new business address to cover my old address on my business cards (white background) and it looks great! Now I just have to see if my husband agrees with me, to continue sticking them onto the business cards... Thank you.
Ever try Handy Label Maker software? Creates general purpose labels, and specializes in labels for individual or mass mailing. Easier and faster than other programs we've tried.
Hi Joey excellent video tutorial on how to create your own labels in open office; it was very helpful to me; but one query I have can you do/create price tags using this technique; just asking.Look forward to your response A.S.A.P! NB: My Finally Question is Does they make the columns automatically when creating labels or do you have to add the amount of columns you want; just confirming & tafs!
Kimberley Gamble I suppose it would depend on the price tags you need. You can get various sizes of labels, including price tags. Using this instruction is more for a single page of labels, either same or different. So if that is all you need, then it should work fine. However, if you need to do multiple pages of labels, possibly different prices and descriptions. Then this would be better solved using a "mail merge". This would allow you to create a Spredsheet of tag descriptions and then merge them into a single label page. The software would then create as many pages as needed to complete the label. I'm afraid I don't have a tutorial video for that, but if you like, I can get you some links to some good instructions. I hope I've been able to help. Please let me know if there is anything more I can do. :)
OK Thanks & Yes you've help. Thanks Also for the additional information given using other medium to do multiple privcing labesl I appreciate it alot.; Thanks! NB: My Questions I wish to ask you; Can you download/install this app on your nexus tablet & would/should it work the same way as on a computer;printing etc. just asking. The Reason I ask was because I did installed this app of my tablet & followed your video tutorial on creating labels using this document but it didn't print out anything & I have an HP Plug In app feature on it.do you know why that is so & I'm I doing something wrong; not sure. Look forward to your Response A.S.A.P!
Kimberley Gamble I have never tried the Android version of OpenOffice. So I'm afraid I am not certain what to expect. Often App versions of a program will have limited functionality compared to their PC version. So I would not be surprised if it was not able to do labels this same way. IF it does have it, and you need to print to an HP ePrint printer, then there should be a "print" function in the menu. OR, you would tap the Share icon and choose the HP ePrint App as the device you wish to share it with. Sorry I can't be more help with this question.
Ok Thanks A Lot & It's Np! I'll try doing the share thing & if it don't work I'll would either do it manually or on the PC as usual so thanks for the tip/advice given.
Open Office Writer will not let me not choose any database (as in, I would like to keep that field blank). It forces me to choose from a list of databases. Due to this, when trying to create a page of blank labels, it will let me type in the first label box, but mark all other boxes as "read only." If I try to type in any box other than the first one, I get the message: "Readonly content cannot be changed. No modifications will be accepted." How do I create a page of labels that are all different from each other?
How do I create custom sized labels (to be printed on a full-sheet label and cut manually)? And further, to have my custom design of the label (text, graphics, etc.) automatically repeat in all of the labels without having to manually paste it dozens of times? The first option in the "Type" box (no matter which "Brand" is chosen) is "[User]" with an apparently unchangeable size/layout of '3.94" x 3.94" (1 x 1)'.
Sorry for the delay getting back to you. When starting the new label wizard. If there is not an Avery Size label that matches your needs, there is an options for [User] at the top of the list. Choose this. Then click the "Format" tab along the top. This is the area you can define the label size, number of columns, rows, spacing, etc. These settings will remain under the [User] label choice until you change it again, so you can easily return to it later if needed. Next, click the "Options" tab. Check the box for "Synchronize contents". This box will place a "Synchronize" button on your document that will allow you to apply all of your formatting you create in the FIRST label to then be applied to ALL labels. I hope this helps.
When the sheet of labels is created, look for a button that says "Synchronize Labels". It is usually a long rectangle button, and may appear as a floating Window around the upper left corner below the toolbars. If you see this button, then you can make all the changes you want to the first label. After the label looks correct, click the "Synchronize Labels" button. It will apply the same changes to every label. NOTE: This applies to creating a page of the same label. If each label is different text, then you will need to edit each label.
I would like to have multiple sheets for labels in a document. How do I add another sheet to a document with labels or must I create a new document of labels?
Sorry for the long delay. This video is several years old, and I don't keep a watch on its comments like I used to. I imagine I'm too late to help you now, but I wanted to reply anyway. I am not aware of a way to sort the labels when creating them this way.. This would be best accomplished by using a database, or spreadsheet file. Using a Mail Merge feature you can take another file, such as a spreadsheet, and merge it in to a label or letter. The spreadsheet would have the tool allowing you to sort your information in alphabetic order before merging. It is not a difficult process, but it does involve several steps. Plus, it helps to have some basic skills in a spreadsheet or database program. I've had several requests for a video instructing how to create labels using a Mail Merge. I may create one soon, so keep watch on my channel. Thanks.
Really helpful video, was wondering if you could direct me to a video on how to add little pictures? Making gifts for the kids teachers at xmas and it'd be cute to add a Santa along with the message. Thanks
I'm sorry I missed your post. Maybe this will help you for next Christmas. When you have your label sheet open, you should be able to add a picture, or clip art, using any saved image on your computer. Have your cursor in the first label where you would like to place the image. Click on "Insert" then "Picture" and "From File". You may then choose the image file you want from your saved files. When the file inserts, you will be able to resize the image, and drag it to the desired placement within the label. Don't forget to change the word wrap so that your text fits properly around it. Do this by right clicking on the image, then "Wrap", and choose the wrap method that creates the desired effect. If you used the feature to synchronize contents for the labels as I described in my video description, then you can click the "Synchronize Labels" button to duplicate the image to all of your labels.
Janice Macak a quick Google search reveals a number of sites offering templates and design options that might help. If you want a specific design, then it would likely require creating a custom label template. Do you have a label design that you wish to use? I'm happy to help if I can.
I don't really have a design label in my. I have a template, but don't really know how to create a label. I have a bad memory so it's had for me to watch a video and remember how to do it. What I really need is written instructions. Do you have any suggestions?
Sorry for the delay. I could provide written instructions to creating basic labels, as given in the video. However, since there is not a predesigned label option to use for your label type, I doubt that would help you. If you obtained a label template from a 3rd party, they may have a downloadable file that would add the required template into OpenOffice for you. It would generally include any instructions needed to install/open the file in OpenOffice. If you have a label design that you need to create your own label template to fit, you can follow the same instructions to create labels, but instead of choosing a label type click the "Format" tab. (Steps would be to open the OpenOffice Writer program, Click File, New, Label. Then click the "Format" tab.) It will then display various measurements required to create a custom sized label. Some websites that offer custom templates for labels will provide you with the measurements to fill in this information. If not, then you may need to resort to using a ruler to measure them out. When creating labels this way, I always print out the first sheet on plain paper and overlay it with my Label to see if the text is aligning with the label where I want it. Then print on the label sheets when ready. I don't know if that helps you much. When working with custom labels there are so many options out there. If you downloaded a label design/template from a website, hopefully they have the measurements for you too. This would save you a bit of measuring and guess work.
To draw a line, make sure that the Drawing toolbar is visible. Click "View" from the menu bar, then move to "Toolbars". You will see a list of toolbars. If you do not see a check mark next to "Drawing", then click on it to select it. Next, look at your visible toolbars for the drawing tools. Mine appeared in the lower left corner of the OpenOffice window, but it can be moved to different locations. It will have several buttons including a line tool, square, elliptical, freehand, etc... You can then select the Line tool button, and draw the line you want in your label. (Note: If you also have the Properties menu open, then when you select the line tool you will be able to customize its color and width. If you have already drawn the line, then use the arrow tool in the Drawing toolbar, and select the line. Then Right click the line, and click "Line" in the alt menu that appears. You will be given a Line Window with the available options.)
Does not help at all the people like myself who are using a zebra zp450 and want to buy a 2x1 or 3x1 single roll of labels. Does not help just need a single setting for 2x1 and 3x1 and need a setting to change it only to single roll of labels.
Sorry your having trouble. You are correct that my instructions do not apply in your situation. Using a label printer is different than the average person using an inkjet or laser printer with sheet fed labels. I'm not familiar with your exact label printer and the settings you might need. As you likely already know, you must have the correct drivers installed for your label printer. In OpenOffice when setting up your labels you will need to choose "Continuous" as the Format, then select the brand and label type for your machine. Some label makers might also require additional settings within the printer driver to correct print issues when the label might be printing sidways, or outside of the label. A quick search about your model label maker indicates that Zebra made that machine specifically for UPS, and Zebra does not offer software or support. There might be some 3rd party software available that might work for the machine. Sorry I can't offer you anything more specific, but I hope that I have been able to at least give you some other ideas to find a solution. Good luck in your search.
Follow the same steps, but click the "Options" tab. There will be a selection for "single label". You can then choose the column and row to create your label.
It's years later and I have Open Office 4. The instructions have not changed for this. Everything is the same!!!! Thank you for the easy follow along step by step on how to make my labels. I uses the free Avery label program but it's got SO many bugs in it that even free wasn't worth it. Thanks again.
I do find it amazing that my video is still helping so many after 7 years. OpenOffice has declined in popularity over recent years, and updates are rare. I still occasionally recommend it to customers, but don't use it much myself anymore. I'm glad that my video was able to help you. Thank you for the comment. :)
I just watched to listen to your soothing voice. LOL and learned as well. :-)
Thanks! :) I'm glad I was able to help.
it only took an hour to follow your instruction and print out my labels of my design. now i'm ready to start my home business. thanks a bunch!
Akie Porter You are welcome. I'm glad I could help.
Thank you so much for taking the time to make this video. I have now made my labels and save a lot of time. Much appreciated👍🏽
Thanks for this simple and easy to follow tutorial. It was much easier than trying to figure it out myself, LOL.
Ideal tutorial to set-up labels both singly or to produce sheet of multiple labels whether individual or page of the same label e.g. "FRAGILE" or "DO NOT BEND" Thanks for your time, well done.
thank you. great video. you made it so easy
You're welcome. Glad I could help
Excellent clear instructions - I would also add you can save the file for future use . Works with TRIO as well
Nice thanks
Thank you sir. That was very informative. I am using Avery ink jet return address labels to type my new business address to cover my old address on my business cards (white background) and it looks great! Now I just have to see if my husband agrees with me, to continue sticking them onto the business cards... Thank you.
I'm looking for a size that is ideal for printing study flip cards. Any suggestions please?
Still relevant and helpful thanks so much!
Thanks for this video. I always wanted to create my own address labels. Thanks to this video I can now do that with open office writer.
Ever try Handy Label Maker software? Creates general purpose labels, and specializes in labels for individual or mass mailing. Easier and faster than other programs we've tried.
Thank you, saved me so much time, searching .... you star.
Thank you so much, not that hard once you know how to do it, but not super intuitive either.
You're welcome.
Hi Joey excellent video tutorial on how to create your own labels in open office; it was very helpful to me; but one query I have can you do/create price tags using this technique; just asking.Look forward to your response A.S.A.P!
NB: My Finally Question is Does they make the columns automatically when creating labels or do you have to add the amount of columns you want; just confirming & tafs!
Kimberley Gamble I suppose it would depend on the price tags you need. You can get various sizes of labels, including price tags. Using this instruction is more for a single page of labels, either same or different. So if that is all you need, then it should work fine. However, if you need to do multiple pages of labels, possibly different prices and descriptions. Then this would be better solved using a "mail merge". This would allow you to create a Spredsheet of tag descriptions and then merge them into a single label page. The software would then create as many pages as needed to complete the label. I'm afraid I don't have a tutorial video for that, but if you like, I can get you some links to some good instructions. I hope I've been able to help. Please let me know if there is anything more I can do. :)
OK Thanks & Yes you've help. Thanks Also for the additional information given using other medium to do multiple privcing labesl I appreciate it alot.; Thanks!
NB: My Questions I wish to ask you; Can you download/install this app on your nexus tablet & would/should it work the same way as on a computer;printing etc. just asking. The Reason I ask was because I did installed this app of my tablet & followed your video tutorial on creating labels using this document but it didn't print out anything & I have an HP Plug In app feature on it.do you know why that is so & I'm I doing something wrong; not sure. Look forward to your Response A.S.A.P!
Kimberley Gamble I have never tried the Android version of OpenOffice. So I'm afraid I am not certain what to expect. Often App versions of a program will have limited functionality compared to their PC version. So I would not be surprised if it was not able to do labels this same way. IF it does have it, and you need to print to an HP ePrint printer, then there should be a "print" function in the menu. OR, you would tap the Share icon and choose the HP ePrint App as the device you wish to share it with. Sorry I can't be more help with this question.
Ok Thanks A Lot & It's Np! I'll try doing the share thing & if it don't work I'll would either do it manually or on the PC as usual so thanks for the tip/advice given.
Thank you so much Sir .
It's helpful .
Thanks Joey. Great help, very easy steps to follow
Open Office Writer will not let me not choose any database (as in, I would like to keep that field blank). It forces me to choose from a list of databases.
Due to this, when trying to create a page of blank labels, it will let me type in the first label box, but mark all other boxes as "read only." If I try to type in any box other than the first one, I get the message:
"Readonly content cannot be changed. No modifications will be accepted."
How do I create a page of labels that are all different from each other?
Can you show how to mail merge existing list to make labels?
How do I create custom sized labels (to be printed on a full-sheet label and cut manually)? And further, to have my custom design of the label (text, graphics, etc.) automatically repeat in all of the labels without having to manually paste it dozens of times?
The first option in the "Type" box (no matter which "Brand" is chosen) is "[User]" with an apparently unchangeable size/layout of '3.94" x 3.94" (1 x 1)'.
Sorry for the delay getting back to you. When starting the new label wizard. If there is not an Avery Size label that matches your needs, there is an options for [User] at the top of the list. Choose this. Then click the "Format" tab along the top. This is the area you can define the label size, number of columns, rows, spacing, etc. These settings will remain under the [User] label choice until you change it again, so you can easily return to it later if needed. Next, click the "Options" tab. Check the box for "Synchronize contents". This box will place a "Synchronize" button on your document that will allow you to apply all of your formatting you create in the FIRST label to then be applied to ALL labels.
I hope this helps.
@@PCsetupHelps Thanks!
Thank you for making learning easy and clear
thanks - helped a lot
Excellent tutorial & well presented. Is there any information on how to print on the inside of a blank greeting card ? Thank you.
How do I make the text fit the cell (label)? It's going to take forever to do each one manually.
When the sheet of labels is created, look for a button that says "Synchronize Labels". It is usually a long rectangle button, and may appear as a floating Window around the upper left corner below the toolbars. If you see this button, then you can make all the changes you want to the first label. After the label looks correct, click the "Synchronize Labels" button. It will apply the same changes to every label. NOTE: This applies to creating a page of the same label. If each label is different text, then you will need to edit each label.
Thank you! Thank you!
how do you shrink the font and then have it apply to all the labels?
Thanks, you saved me lots of time!
Richard Howells, I'm glad you found my video helpful. Thanks for watching.
I would like to have multiple sheets for labels in a document. How do I add another sheet to a document with labels or must I create a new document of labels?
Thank you Sir. Thanks to RUclips also. God bless you.
Very helpful. Thank you very much.
Can't paste Christmas clip art?
Very well explained..
Thank you very much. Great help.
How do I do them so that they print in alphabet order?
Sorry for the long delay. This video is several years old, and I don't keep a watch on its comments like I used to. I imagine I'm too late to help you now, but I wanted to reply anyway. I am not aware of a way to sort the labels when creating them this way.. This would be best accomplished by using a database, or spreadsheet file. Using a Mail Merge feature you can take another file, such as a spreadsheet, and merge it in to a label or letter. The spreadsheet would have the tool allowing you to sort your information in alphabetic order before merging. It is not a difficult process, but it does involve several steps. Plus, it helps to have some basic skills in a spreadsheet or database program. I've had several requests for a video instructing how to create labels using a Mail Merge. I may create one soon, so keep watch on my channel. Thanks.
Why don't u use database?
Really helpful video, was wondering if you could direct me to a video on how to add little pictures? Making gifts for the kids teachers at xmas and it'd be cute to add a Santa along with the message. Thanks
I'm sorry I missed your post. Maybe this will help you for next Christmas. When you have your label sheet open, you should be able to add a picture, or clip art, using any saved image on your computer. Have your cursor in the first label where you would like to place the image. Click on "Insert" then "Picture" and "From File". You may then choose the image file you want from your saved files. When the file inserts, you will be able to resize the image, and drag it to the desired placement within the label. Don't forget to change the word wrap so that your text fits properly around it. Do this by right clicking on the image, then "Wrap", and choose the wrap method that creates the desired effect. If you used the feature to synchronize contents for the labels as I described in my video description, then you can click the "Synchronize Labels" button to duplicate the image to all of your labels.
This was extremely helpful. I tried downloading templates for mailing labels and got nothing but intrusive add-ons to Chrome, etc.
Thanks, very good video.
Do you know how to make cigar band labels? I could use some help.
Janice Macak a quick Google search reveals a number of sites offering templates and design options that might help. If you want a specific design, then it would likely require creating a custom label template. Do you have a label design that you wish to use?
I'm happy to help if I can.
I don't really have a design label in my. I have a template, but don't really know how to create a label. I have a bad memory so it's had for me to watch a video and remember how to do it. What I really need is written instructions. Do you have any suggestions?
Sorry for the delay. I could provide written instructions to creating basic labels, as given in the video. However, since there is not a predesigned label option to use for your label type, I doubt that would help you. If you obtained a label template from a 3rd party, they may have a downloadable file that would add the required template into OpenOffice for you. It would generally include any instructions needed to install/open the file in OpenOffice.
If you have a label design that you need to create your own label template to fit, you can follow the same instructions to create labels, but instead of choosing a label type click the "Format" tab. (Steps would be to open the OpenOffice Writer program, Click File, New, Label. Then click the "Format" tab.) It will then display various measurements required to create a custom sized label. Some websites that offer custom templates for labels will provide you with the measurements to fill in this information. If not, then you may need to resort to using a ruler to measure them out. When creating labels this way, I always print out the first sheet on plain paper and overlay it with my Label to see if the text is aligning with the label where I want it. Then print on the label sheets when ready.
I don't know if that helps you much. When working with custom labels there are so many options out there. If you downloaded a label design/template from a website, hopefully they have the measurements for you too. This would save you a bit of measuring and guess work.
Great!
Glad you found this old video helpful.
Thank you!
Thanks, great help, I was struggling I must admit.
You're welcome. Glad I could help.
Very well done! Thank you.
My Avery number is 22804 and of course Open Office isn't offering that. Damn...
Thank you so much :)
You're welcome. I'm glad I could help.
hit the button that says, "Synchronize Labels". That should change all of them.
Thank you. Helped for my assignment :)
well-done
Are you still active
I am still here. I don't monitor this video much since it's so old. But I try to respond when I can.
Sir please tell me how to draw Lin in label
To draw a line, make sure that the Drawing toolbar is visible. Click "View" from the menu bar, then move to "Toolbars". You will see a list of toolbars. If you do not see a check mark next to "Drawing", then click on it to select it. Next, look at your visible toolbars for the drawing tools. Mine appeared in the lower left corner of the OpenOffice window, but it can be moved to different locations. It will have several buttons including a line tool, square, elliptical, freehand, etc... You can then select the Line tool button, and draw the line you want in your label. (Note: If you also have the Properties menu open, then when you select the line tool you will be able to customize its color and width. If you have already drawn the line, then use the arrow tool in the Drawing toolbar, and select the line. Then Right click the line, and click "Line" in the alt menu that appears. You will be given a Line Window with the available options.)
how could i add continuous numbering in labels, thanks in advance.
1:11 is when they get to the point
MrSeinfeldFan2, did you see this video? ruclips.net/video/_vIIaOUP_BQ/видео.html
Does not help at all the people like myself who are using a zebra zp450 and want to buy a 2x1 or 3x1 single roll of labels. Does not help just need a single setting for 2x1 and 3x1 and need a setting to change it only to single roll of labels.
Sorry your having trouble. You are correct that my instructions do not apply in your situation. Using a label printer is different than the average person using an inkjet or laser printer with sheet fed labels. I'm not familiar with your exact label printer and the settings you might need. As you likely already know, you must have the correct drivers installed for your label printer. In OpenOffice when setting up your labels you will need to choose "Continuous" as the Format, then select the brand and label type for your machine. Some label makers might also require additional settings within the printer driver to correct print issues when the label might be printing sidways, or outside of the label. A quick search about your model label maker indicates that Zebra made that machine specifically for UPS, and Zebra does not offer software or support. There might be some 3rd party software available that might work for the machine. Sorry I can't offer you anything more specific, but I hope that I have been able to at least give you some other ideas to find a solution. Good luck in your search.
Need just single labels.
Follow the same steps, but click the "Options" tab. There will be a selection for "single label". You can then choose the column and row to create your label.
Thank you - very helpful.