Collaborate on Libreoffice Invoice Template for Marketing with Ease Using airSlate SignNow

Libreoffice invoice template for Marketing

hey everybody melissa here so today i'm in libreoffice writer and i'm going to show you how to create address labels now i'm going to show you how to create both return address labels and mailing and shipping labels so let's go ahead and get started so there are a couple ways we can create return address labels we can do them manually or we can kind of automate the process but let me show you manually first if we go to file new labels we can actually type in here your company 123 your street your city kentucky and put in the zip now on our options we want to make sure it says entire page and we want to make sure that it's got synchronized contents checked and back on our labels we want to tell it sheet because if you have an inkjet or laserjet or anything like that then you're putting in sheets for it to create your labels and then we're going to tell it the brand and i'm going to do every letter size and then mine is like 51 and then i'm going to tell it new document and there is your address labels and then you can print off as many pages as you need to print off now let's look at how we can automate it so to automate it the first thing we want to do is come up here to tools go to options and we want to fill in our company information so we're going to do your company and we're going to go 123 your street and your city kentucky four zero zero zero zero and we're going to tell it applying okay now if we go to file new labels and we click here and we tell it address look what it does it brings in whatever we typed in into our options now it does have a space here we can just remove that and that way there's no spaces in between there or you can leave it that's up to you and then of course our brand is going to stay the same we still want to sheet our options are going to be the same entire page and synchronized contents the only difference is we do not have to type this in every time we can just click on address it fills it in new document and there's your address labels so now let's look at shipping labels and mailing labels that have different addresses so i have my mailing or shipping addresses in a libreoffice calc spreadsheet so the first thing i want to do is make sure this is saved so we'll just go to file save as and it'll take us to the location it's at tell it to save and in this case since i've already got it done i'm just going to tell it yes to replace it so now what we have to do is we have to create a database so don't worry when i say we have to create a new database libreoffice makes it easier than any other office suite to create these from within any of their applications so it's really pretty easy we're going to go to file new database and then we're going to tell it to connect to an existing database and that means we're going to create this database from our librecalc spreadsheet so we're going to do our drop down here and we're going to tell it spreadsheet then we're going to tell it next and even though we have this open in the background we need to tell the database where to find it so we're going to browse and i've got mine in this temp folder and i'm going to tell it that document then i'm going to tell it next and it's going to register the database which is what we want it to do and we're going to say finish and now it's asking us where do you want me to save it well i'm going to tell it in the same place and i'm just going to call it new database and tell it to save it and now it brings up our database now what we want to do from here is we want to go to file new labels and we're going to tell it our database is new database because that's what we called it so whatever you call your database is what you'll put here our table is going to be sheet1 and our database field is going to be what order do we want these fields to be over here so we're going to say name and then we're going to hit enter then we're going to say street address had it hit enter then we're going to do city state and zip add it and then of course our brand is going to be the same we want it to be the sheet because that's what we use our options our entire page and synchronize contents now you can do some formatting in here you can change your horizontal pitch your top margins bottom margins depending on how much information you have on your address label but for this i don't need to change any of those so i'm going to tell it new document now when it brings this up as you can see it opened it back up in writer and it doesn't have our information from our database this is showing us what the layout's going to look like so let's just say that we wanted these centered if you notice we have a synchronized label button here let's highlight them let's just say we want this centered and hit synchronize labels it centered all of them so let's just say we do that and we're like no that's not really what i wanted to do so just highlight it put it back synchronize and it'll put them all back so any kind of formatting you do here let's just say you want to vote it synchronize your label let's just say you want to put it back so any kind of formatting you do the size the color do it to your first one click synchronize labels and it does it to all of them now if you actually want to see what is in your database here we're going to go to file print and when this box pops up it's just asking us basically do you want to take what's in your database and superimpose it here so you can see what it's going to look like yes we do and this is what it's pulling from our database it gives us a preview and we're going to tell it instead of a printer because we want to preview it and not print it just yet we're going to tell it a file and as a single document and tell it okay and now it's going to ask us is this where you want me to save it i do and i'm going to name this one address labels and i'm going to tell it to save it mail merge done now if i go back to that folder and pick up address labels and open it there is everything from my database and that's how you can create either return address labels or mailing and shipping address labels within libre libreoffice writer if you found this video helpful please give it a thumbs up if you'd like to see more content like this in the future please be sure to subscribe to my channel before you go and i'll see you in the next tutorial until then thanks so much for watching