Part 1: Register Your Database with the Address Book Data Source Wizardīefore creating any labels, the first thing you need to do is create your database. And, in fact, the first step will seem unrelated to merging labels, but it is necessary. LibreOffice is fully capable of doing this, but it’s not what I would call “easy” or straightforward. The idea behind a label merge, just like a form letter merge, is that you have a bunch of address information in a spreadsheet or database and, rather than having to enter all of that separately into a document to print labels, you’ll just have the software create the labels from the data you already have. So, here is my tutorial on how to merge labels in LibreOffice. Whenever that happens, I know that means I need to create a tutorial on here so I can remind myself how to do it if I ever need to do it again. In the process, I realized that I totally forgot how to do it after the first time. The first time, I actually did a form letter and a label merge the second time I just had to do an address label merge. Once you get the hang of the process, creating both envelopes and labels is not a hardship or extensive time sink.I’ve been using LibreOffice for over a decade and have only had to do an address label merge twice in that time – both of which have been in the last month. Unless you delete the file, you will be able to use the database for most of your business’s existence.Ĭreating labels and envelopes are one way you can have your small business look like a big company without the financial cost of it. Access is a search-enabled database software, which allows you to search for a particular file. You can either put the addresses in all at once or one at a time over an extended period of time. Both software applications are simple to use and import the same way into Word. The process is similar, but you have greater possibilities as this software has customizable layouts.ĭatabase Tip: To create a database of addresses to use when you print labels, input each address into Access or Excel spreadsheet. Quick Tip: Publisher, another software in Microsoft Office suite, also creates envelopes and labels. Arrange the sheets or envelopes in the printer before you press print. Step 7: Continue to click “Next” for the next three steps until it lets you print. It will prompt you to find the file and upload. If you choose “Use an existing list,” follow the directions on the screen in the connection wizard to import the addresses. Step 6: Find the list of addresses, type in the addresses, or use the list from Outlook. You can use this option, if you only need a handful of envelopes or labels to print. The final option, “type a new list,” is the most time consuming as you have to type in each address. If you have a database of addresses in Access or Excel, choose “Use an existing list.” You can import from Outlook by selecting the third option. It’s the size.of the labels or envelopes. Click “Next.” The numbers probably seem confusing, but the one you need is located on the box of the labels or envelopes. Step 4: Choose the type of printer and label or envelope. Step 3: Mark “Change Document Layout.” Click “Next.” Two other options are possible, but either way you will need to change the layout to fit envelope or label template. Step 2: Choose “Labels” or “Envelopes” from the options on the side panel. Click on “Tools.” Graze “Letters and Mailings” with your mouse. Step 1: Open up Microsoft Word to a new document.
Database of Addresses (or a wiliness to input them).