 Okay, a week or two ago I did a tutorial on printing out address labels using LibreOffice if you had a spreadsheet of contacts and networks and LibreOffice's cross-platform, which is great. So no matter what operating system you have, you should be able to run it on there. But a little bit easier, I think, is G-labels, which is specifically designed for creating labels, not only address labels but like CD labels and stuff like that. It's very simple to use, unfortunately I think it's Linux only, as far as I know it might run on BSD or something like that, but I don't think it's available for Windows or Mac, which is unfortunate. But luckily anyone can use Linux whether you commit to an install or just run an office CD or USB flash drive or an SD card or something like that. So really no restrictions there. I'm just going to show you how to work this, because although it's very simple, if you've never done it before, there's a few things that might be a little confusing. So I'm going to say New, and it shows your recent stuff, but by default the first time you come in I think it will be here on your search all. And here you can choose the brand of your labels. I'm going to choose Avery because they're fairly common, the page size, and then you can narrow down the category, we'll say mailing and shipping products. And then here you can choose the model of labels you have, so on your package of labels there should be a number, so like this is Avery 7162. And once you find the one you're looking for, you can click Continue, ask what orientation you want, I would just do normal. And then here last screen, on some of the labels I've tried, it will have a long list of similar products. So if you have fairly common labels, maybe they've changed the model number over the years and changed them slightly, it will show a list of similar products here. So we'll just click Apply, and this is what the label looks like. So here I can click on the T here for text, I can input some text, I can just say Tommy Jones, 123 Pine Street, Naples, Florida, 43120. And so that's what your label would look like. You can change the style of the font here for the text. We can up the size, change the fonts to something else if you wanted, and then line it up. And then at this point, you can also add images here, you can add barcodes, different shapes, so you can do a lot with how your labels look. So if you wanted to have a nice background image, you could do that. But it's fine, I'm going to click Print, and I'm going to go Print Preview. And you'll see that this is great for return address, because all your labels would be the same, and that may be what you want. But let's say it's Christmas time, as it is right now when I'm recording this video, and you're going to be sending out a whole bunch of letters to friends, and you want to print up labels based on your contact sheets, whether it be in your Google contacts, or you have a spreadsheet like our other example the other day. So what we're going to do here is we're going to close this Print Preview, and I'm going to delete that text box. What I'm going to do is I'm going to go Objects, Merge Properties. Then you're going to choose your format. Now, I've mainly used, and in this tutorial we're going to use the CSV, the comma separated values. Also, I've tried vCards. These are two very common types of plain text files. If you have a spreadsheet, you should be able to export it as a CSV. And if you have contacts, let's say in your Google contacts, you have options for CSV or vCard, they're both very common. But there's some other options here as well. I'm going to choose CSV, and then I'm going to find my CSV file, just a little example file I made. And here it gives you a list of what's in that file. So we can expand these, and you can see this is the information that is available for each of those contacts. And now look and remember, you have a 1, 2, 3 here, because if you export from something like Google Docs, you will have probably a lot more information other than just the address. You'll probably have their email address, their phone number, maybe their date of birth. So find the items you want. Should be the same for each contact, probably their name, street address, and then city, state, and zip. Find those and look at what their numbers are and write them out if you have to. In this case, I have a very simple file. I have 1, 2, and 3. And I'll click OK. Notice nothing comes up on the label. This was the part that confused me for a little bit, so I had to Google it. What we're going to do is we're going to add another text box. And what I'm going to do here is I am going to go dollar sign and then squiggly braces or curly braces. And I'm going to do that three times. Now remember the numbers we were looking at before? 1, 2, and 3? Well, that's right. These are placeholders. Wherever you place this and with the number will be that item. So you can go a different order. I could go name on the second line if I want. But I'll show you that in a second. So we have our placeholders here. I am going to go print again and I'm going to go print preview. And here you can see that we have our contacts as they will print on the labels, each one with their name address. And if we come in here, I'll show you again. If we change, let's say we go 2 and 1 here. And I go print and I'll do a print preview. You can see now the name is on the second line. So that's how you organize it. And of course, you can have other stuff on there depending on what you're doing. I could type in here name. And then if I go print, print preview, you'll see it print the word name. And then we'll put in the person's name based on this placeholder. So that's fairly simple once you know how to do it. And I already mentioned that you can do pictures, barcodes, and different shapes in the background here. So if you wanted nice labels, you can put an image. Or if you wanted a barcode, if you're doing company stuff for people to scan, you can do that as well. I'm going to give you another example here, though, because I hate working with labels. So I am going to come in here. I'm going to say brand and any. I'm going to say page size. And I am going to choose number 10 envelope, just because that's the size envelope I'm using. You can see here it tells you what size it is. And I'm just going to click continue. I'm going to say rotated. And it'll tell you what size is up, apply. So let me bring this up here, because I open up a new window, get it in the recording area here. So this is actually not just a label. This is a full envelope. And so I can do something like add text up here. And I can say Tommy, Carter, 123, Pine Street, Naples, Florida, and the zip code. And of course, I can make that bigger and change the font if I'd like. Same as before, you can put images in the background. You can add a bar code if you want. So you can add that down there and put in what it would be valued at if you did a valid bar code, because you can't just type in any number. If it's a valid bar code, it's got to be a specific length and characters, depending on the different types of bar code. Getting a little off topic here. And again, you can add shapes if you wanted shapes. But we need to now, let's say we want to print up a different envelope for each person we're mailing to. Same as before, I'm going to add a second text box here. And I'm going to type in my braces with squigglies. I already know that the list I'm using is going to be 1, 2, and 3. And I'm going to say objects, merge properties, CSV, choose my CSV file, make sure you can look at the information, make sure it's right. Get those numbers that you need, which I've already put in here. I'm going to up the size of the font a little bit. And now if I go print preview, it's going to preview it sideways, unfortunately, because, ooh. OK, see how the return address is a little messed up there? That's because that's my fault for not resizing this to fit where the address is going to be. So now that I have resized it properly, we'll go print, print preview. And now you can see the address and name. That's the first page, because each envelope is going to be a new page. There's a second page. And there's the third page. You can see that each time the return address has stayed the same, but the person you're, oh, I should probably get this in the record area so you can see. So you can see return address is the same on each, but the mailing address that you're mailing to has each of the contacts that you imported. So now you can just load up your printer with all your envelopes and just click print, which is what I prefer to do. I don't like working with labels. So that's it. You can have a full image in the background if you want to use up all your ink. But that's using G labels. And once again, it can do a bunch of other things other than just mailing addresses, photo products, foldable cards. So you can make cards, business cards, rectangular labels, round labels. You can also just leave all these up to any and you can scroll through here. And you'll see you have different types of CD labels and DVD labels. I bet you can probably do DVD cases. And here would be a guess as well, different size. So G label, very easy to use. Once you know the little secret of doing the merge properties and then assigning the values and placing them where you want. So I thank you for watching. I hope that you enjoyed this tutorial. Please visit filmsbychris.com. That's Chris with the K. There should be a link in the description. And I just hope that you have a great day. Be sure to like and subscribe to my videos. Have a great day.