How to print address labels using openoffice

Before beginning this process, note the brand and type of labels you intend to use.

To print mailing labels:

  1. Click File > New > Labels.
  2. On the Options tab, ensure that the Synchronise contents checkbox is selected.
  3. On the Labels tab, select the Database and Table. Select the Brand of labels to be used, and then select the Type of label.

How to print address labels using openoffice If the type of label you wish to use is not on the list, you need to use the Format tab to define a new Brand and Type. This is beyond the scope of this document, but is relatively simple to implement, given knowledge of the dimensions of the label.

How to print address labels using openoffice

How to print address labels using openoffice

How to print address labels using openoffice

How to print address labels using openoffice

How to print address labels using openoffice

How to print address labels using openoffice

You will now see that address field separation is created by line breaks How to print address labels using openoffice, rather than paragraphs How to print address labels using openoffice. As the suppression of blank address fields depends on hiding paragraphs, not lines, you need to replace line breaks with paragraphs as follows.

Click in the first label, at the end of the last data source address field in the first line of the label. Press Delete to remove the new line character and then press Return (or the Enter key) to insert a paragraph marker. Repeat this action for each line in the address.

If the line spacing in the first label is not satisfactory, you may wish to correct this before proceeding, by modifying the paragraph style associated with the address. Unless you have changed it, the address uses the Default style.

How to print address labels using openoffice The objective of step c) is to replace all line breaks at the end of data source address fields with paragraphs. Sometimes the address data field may be longer than the width of the label and will wrap to the next physical line: make sure that you are not misled by this into deleting and replacing anything other than line break characters.

For example, in our Points database the condition to test if the Company field is empty would be ![Points.Sheet1.Company] as illustrated in Figure 12.

To test for multiple conditions, use the operators AND and/or OR between the conditional statements, for example:

Click Insert, but do not close the dialog until all lines have been amended.

Repeat for each paragraph to be conditionally suppressed, remembering to advance the cursor to the end of the line in question before changing the last element of the condition and Inserting the result.

A clue that you omitted this action is the observation that some records have been skipped and are missing from the final output.

You now have a template suitable for future use with the same data source and type of label. If you wish to save it, use either File > Templates > Save as, or save it as an Open Document Text Template (.ott) into the private template directory (folder) that you have previously defined in Tools > Options > OpenOffice.org > Paths > Templates.

The labels are now ready to be printed

  1. Click File > Print. In the message box that appears, click Yes.
  2. In the Mail Merge dialog, you can choose to print all records or selected records. To select records to be printed, use Ctrl+click to select individual records. To select a block of records, select the first record in the block, scroll to the last record in the block, and Shift+click on the last record.
  3. Click OK to send the labels directly to the printer.

If you prefer to save the labels to a file, perhaps to allow some later editing such as changing the typeface or paragraph format, then you should select File in the output section of the Mail Merge dialog box, rather than using the default Printer selection. This changes the dialog box to highlight the Save merged document section, where Save as single document is preselected.

In this case, clicking OK brings up the Save as dialog box, where a file name can be entered for the saved labels. If you did not save the prototype label fields document (template) in step 6f, then you are prompted to do so now by another Save as dialog box.

In either case, whether printing or saving to file, despite there apparently being only one page of labels, the printed or saved output will be expanded to include all of the selected records from the data source.

Editing a saved file of mailing labels

To edit a saved file of mailing labels, open the saved label file in the normal way. You will be prompted as to whether you wish to update all links. Choose No for the following reason: The first label on the page is termed the “Master Label” and all other labels are linked to it: if you update the links then all labels will end up containing the same data, which may not be what you want.

You can edit individual records in the normal way, by highlighting and changing the font name, for example.

However, you cannot edit all labels globally (for example, to change the font name for all records) by the technique of selecting the entire document. To achieve this result you have to edit the paragraph style associated with the label records as follows:

    Right-click any correctly spelled word in a label record. Select Edit Paragraph Style from the pop-up menu. (Note: If you click on a misspelled word, a different menu appears.)

To print labels:

  1. Choose File > New > Labels on the menu bar. The Labels dialog box opens.
  2. On the Labels page, fill in your own label text in the Inscription box, or use the Database and Table drop-down lists to choose the required information as described in Setting up envelope details from a database

How to print address labels using openoffice
Labels dialog box, Labels page.

Select the label stock in the Brand drop-down list. The types for that brand then appear in the Type drop-down list. Select the size and type of labels required. You can also select User in the Type drop-down list and then make specific selections on the Format page).

How to print address labels using openoffice
Labels dialog box, Format page.

  • On the Format page, choose the pitch, sizes, margins, columns and rows for user-defined labels, or just verify with a brand of label stock you have loaded into the printer.
  • Click Save to save your new format.
  • On the Options page, choose to print the entire page of labels or one single label, then select which one by the column and row. You can also change printer setup.

    How to print address labels using openoffice
    Labels dialog box, Options page.

  • When you have finished formatting, click New Document to make your sheet of labels or click Cancel (or press the Esc key). You can also click Reset to remove your changes and return to the original settings when the dialog box opened.
  • You can print right away using the Print File Directly icon on the toolbar or by choosing File > Print from the menu bar, or you can save the file to print later.
  • Post by zykta » Thu Mar 17, 2022 2:57 am

    im after some help please and am just totally lost i have tried so many times to make address labels with a picture inside but i just have no idea what im supposed to do i have got as far as file pick address label and once have picked the address label i just have no idea what im doing next is there any walk through videos or can some one please tell me what i need to do next

    im not sure if i have posted this in the correct place i do hope that some one can help me

    Thank You
    zykta

    Edit: Changed subject, was totally lost
    Make your post understandable by others
    — MrProgrammer, forum moderator

    How to print address labels using openoffice

    Re: Make address labels with a picture inside

    Post by robleyd » Thu Mar 17, 2022 3:43 am

    Re: Make address labels with a picture inside

    Post by zykta » Thu Mar 17, 2022 11:15 pm

    Re: Make address labels with a picture inside

    Post by John_Ha » Fri Mar 18, 2022 12:33 pm

    If they are identical address labels it might be easiest to set up a table where each cell is a label the same size and position as your sheet of labels.

    Now do one cell and copy its contents to all the other cells. Print and voila! (OK – that’s because I’m on holiday in Paris)

    LO 6.4.4.2, Windows 10 Home 64 bit

    Remember: Always save your Writer files as .odt files . – see here for the many reasons why.

    Re: Make address labels with a picture inside

    Post by zykta » Fri Mar 18, 2022 5:29 pm

    Thank you very much for your reply i hope you are having a lovely holiday , yes thats what im wantingto do but im having problems inserting both text and a picture when i have written my text i have no idea how to add a picture so they can be side by side i have tried loads of times but when i add the picture it ends up between the writing or way to big and i cant make it smaller

    How to print address labels using openoffice

    Re: Make address labels with a picture inside

    Post by RoryOF » Fri Mar 18, 2022 5:39 pm

    Re: Make address labels with a picture inside

    Post by zykta » Fri Mar 18, 2022 6:54 pm

    Thank you but i seem to have trouble getting a text box beside my picture when i have got it to the shape i want because the cursor is always in the bottom left had corner how can i move that to the top so i can write
    Thanks
    Zykta

    ps so sorry im finding it so hard

    Re: Make address labels with a picture inside

    Post by John_Ha » Fri Mar 18, 2022 8:16 pm

    LO 6.4.4.2, Windows 10 Home 64 bit

    Remember: Always save your Writer files as .odt files . – see here for the many reasons why.

    Re: Make address labels with a picture inside

    Post by zykta » Sat Mar 19, 2022 6:17 pm

    Re: Make address labels with a picture inside

    Post by John_Ha » Thu Mar 24, 2022 12:13 pm

    If by “other side” you mean the back side of the paper (as opposed to left and right sides on the front of the paper) you need two pages in your document where one page has the addresses and the other page has the images. Be sure the images and text line up in the correct place with your labels.

    If you have a printer which prints on both sides just print it. If your printer only prints on one side of the paper you need to print the first page on the paper; then put the paper back in the printer and print the other side.

    LO 6.4.4.2, Windows 10 Home 64 bit

    Remember: Always save your Writer files as .odt files . – see here for the many reasons why.

    How to print address labels using openoffice

    Search Support

    1. Home
    2. Support Forums
    3. Thunderbird
    4. How to print mailing labels from my.

    Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

    Learn More How to print address labels using openoffice

    How to print address labels using openoffice

    How to print mailing labels from my Thunderbird adress book?

    • 2 replies
    • 4 have this problem
    • 29 views
    • Last reply by ChrisSchaefer

    How to print address labels using openoffice

    I want to print mailing labels, such as Avery 8164, from an address book or a mailing list in my Thunderbird Address Book. How can I do that?

    Chosen solution

    Thunderbird only has the ability to print emails or an address book.

    Thunderbird is not the correct software for wanting to perform something like printing labels. You would need to use MSOffice package or OpenOffice.org (free) see link: https://www.openoffice.org/

    Using OpenOffice.org Base you can select to connect to an existing database and select Thunderbird Address Book. After saving to a suitable location, you can then use OpenOffice.org Writer. File > New > Labels select the saved filename.odb database.

    All Replies (2)

    Chosen Solution

    Thunderbird only has the ability to print emails or an address book.

    Thunderbird is not the correct software for wanting to perform something like printing labels. You would need to use MSOffice package or OpenOffice.org (free) see link: https://www.openoffice.org/

    Using OpenOffice.org Base you can select to connect to an existing database and select Thunderbird Address Book. After saving to a suitable location, you can then use OpenOffice.org Writer. File > New > Labels select the saved filename.odb database.

    How to print address labels using openoffice

    How to print address labels using openoffice

    Thanks for your help. I was afraid this would be the case–seems like a serious shortcoming for a computerized address book. (BTW, you can also make a Thunderbird mailing list of the addresses you want, export it to an Excel file (.cvs), and then use Avery’s “Avery Wizard” plug-in for Microsoft Office to print any of their labels (their software has a few bugs, though).)

    IF in a OpenOffice 2.3 document, Click F ile > N ew > S preadsheet . (A new spreadsheet appears on the screen that is named Untitled1 – OpenOffice.org Calc )

  • IF not in a OpenOffice document, click > All Programs > OpenOffice.org 2.3 > OpenOffice.org Calc . (The name of the file Untitled1 – OpenOffice.org Calc appears on the screen)
  • Change Column Width

    Right-click on the A that is at the top of the first column. (A menu appears)

    Click Col u m n Width. (The “Column Width” window appears.)

    In the W idth dialog box, click on the top upward facing triangle of the to select 1.19” . Click OK .

    Select both columns B and C . To do this, click on the B at the top of the second column and while holding down the button on your mouse, move the pointer over to column C . (Both columns become highlighted) Release the click. Right-click on either B or C (A menu appears)

    Click Col u m n Width.

    In the Width dialog box, use the to select 1.49” . Click OK .

    Change the width of columns D and E to 0.99” .

  • Change the width of column F to 0.59” . (Press the bottom downward facing triangle)
  • Add Titles To Columns

    This tutorial suggests specific titles. At any time in the future, you can change column titles, add or delete columns, and change column widths.

    Click In cell A1 then type First Name .

  • In cells B1 through F1 enter the following titles: Last Name – Street – City – State – Zip Code .
  • Center Titles

    Select all the names by starting at cell A1 (The “First Name” column) and drag your mouse over all the names ending at cell F1 (The “Zip Code” column).

    Click on the Centered icon found on the Formatting Toolbar. (The titles of the columns are centered.)

    Click cell A2, then type the first name, William .

    Click cell B2 . (The cursor moves to cell B2.) Type the last name, Jones.

    Click cell C2 . (The cursor moves to C2.) Type the name of a street, 1 Main Street .

    Add New York to cells D2 .and E2 .

    Add 01111 to cell F2

  • In row 3, enter Sam, Smith, 2 First Avenue, Chicago, Illinois, 54321 and in row 4, enter Ann, Baker, 3 East Drive, Denver, Colorado, 98765 .
  • Format The Zip Code Column For Five Digits Zip Codes

    Right-click on the F at the top of the Zip Code column. (The column is highlighted and a menu appears).

    Click F ormat Cells (The ‘Format Cells” window appears)

    Click the Numbers tab.

    Under C ategory , click Number.

    Under F o rmat, click General.

    In the Leading z ero s box, increase the number 1 to a 5.

    Click OK . (A zero appears at the beginning of the “01111” zip code).

    Click F ile > Pa g e Preview . (A picture of page 1 appears on the screen.)

    Click the Close Preview button. (Your address book appears back on the screen.)

    There is a dark vertical line going down the page that probably is between columns G and H . That line is the edge of the printed page.

    Select cells A1 through F1 . (To do this, click in A1 then drag to cell F1.)

    Right-click in any one of the selected cells, then click C opy . (The titles of the columns are copied to the clipboard.)

    Scroll down until you see the dark horizontal line .

    Click on the cell in column A that is on the row just below the dark horizontal line . Right-click then click P aste . (The titles of the columns are copied to the 1 st row of the 2 nd page.)

  • On the 2 nd row, type the following in the appropriate columns: Betty , Doe , 4 West Lane , Austin , Texas , 55555.
  • Save The Address Book

    Click F ile > Save A s. In the Save in : box, select My Documents .

    In the File name : box, type Address_Book_Spreadsheet.

    In the Save as type : box, select OpenDocument Spreadsheet (.ods) .

    Click the Save button.

    In Part 1 of this Tutorial, you created and saved the Address Book . You need to register the Address Book.

    Open A New Text Document

    IF on the desktop, click > All Programs > OpenOffice.org 2.3 > OpenOffice.org Writer .

    IF you are in Writer or Calc , click F ile > N ew > T ext Document .

  • In either case, the text document appears on our screen.
  • Register An Address Book As A Data Source

    Click F ile > T emplates > A ddress Book Source. (the “Templates: Address Book Assignment” window appears)

    Click on the Administrate. button. (The “Address Book Data Source Wizard” window appears) Select Other external d ata source . Click N ext> .

    Click the Settings button. (The “Create Address Data Source” window appears)

    In the Database t ype pull-down menu, select Spreadsheet . Click N ext>> . (The “Database properties – Connection settings” window appears)

    Click the Browse button. (The “Open” window appears) In the Look in: pull-down menu, select My Documents . Click on Address_Book_Spreadsheet . (The name appears in the “File name:” pull-down menu box) Click on the Open button. (Under “Path to the spreadsheet document”, you will see “ C;\Documents and Settings . . . ”

    Press the Test C onnection button. (A message appears, the connection was established successfully). Click OK > Fi nish . (A window with “Field Assignment” appears)

    Click the Field Assignments button. (The “Address Data – Field Assignment” window reappears)

    Select the Fields that will be printed on the labels.

    The Address Data – Field Assignment window is on the screen.

    In the First name pull-down menu box, select First Name .

    In the Last name pull-down menu box, select Last Name .

    For Street , select Street .

    For Zip Code select Zip Code .

    For City select City .

    For State select State .

    In the D ata source , pull-down menu, there will be the word, Addresses and a number may also be there. Write down or remember what is there, you will use Address later.

    Click the OK button. (The words “Data Source Name” appears within the “Address Book Data Source Wizard” window )

    Click Finish button. (The window appears.)

    Click F ile > N ew > L abels . (The “Labels” window appears.)

    Click on the Options tab.

    If there is a check mark in the small box before Synchroni z e contents , click on the check mark to remove the check mark.

    Click on the Labels tab.

    In the D atabase pull-down menu, select Addresses . (There may be a number with the Addresses depending upon what you did previously in Part 2.)

    In the Ta b le pull-down menu, select Sheet1 .

    In the B rand pull-down menu, select Avery Letter Size .

    In the T ype pull-down menu, select 5260 Address .

    In the Database f ield pull-down menu, select First Name then Click on (“” appears in the “Label text” box.)

    In the Database f ield pull-down menu, select Street then Click on (“” appears in the “Label text” box on the 2 nd line.)

    Place City , State , and Zip Code into the label text box.

    Click N ew Document . (The “Labels – OpenOffice.org Writer” window appears)

    Click F ile > P rint . Click Yes to Your document contains address database fields. Do you want to print a form letter? (The “Mail Merge” window appears)

    Click T ools > M ail Merge Wizard . Select. Use the current d ocument . Click on 8. Saver, print, or send . Click Save the Document . (The “Save As” window appears)

    Save in My Documents folder with the name My Address Labels . Click Finish button.

    Click OK . Print the labels.

    Tutorials are improved by input from users. We solicit your constructive criticism.

    Click here to E-mail your suggestions and comments

    User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

    • Unanswered topics
    • Active topics
    • Search

    [Solved] Address label template how to.

    [Solved] Address label template how to.

    Post by [email protected] » Sat Dec 12, 2015 5:53 pm

    How to print address labels using openoffice

    Re: Address label template how to.

    Post by acknak » Sat Dec 12, 2015 9:28 pm

    Greetings and welcome to the community forum!

    What is it you’re trying to do? Fill in a sheet of address labels? Address an envelope?

    What template are you working with–can you paste the address here of the page you downloaded from so we can see what you’re working with?

    Re: Address label template how to.

    Post by [email protected] » Sat Dec 12, 2015 10:54 pm

    How to print address labels using openoffice

    Re: Address label template how to.

    Post by RoryOF » Sat Dec 12, 2015 10:57 pm

    Re: Address label template how to.

    Post by [email protected] » Sat Dec 12, 2015 11:13 pm

    How to print address labels using openoffice

    Re: Address label template how to.

    Post by RoryOF » Sat Dec 12, 2015 11:17 pm

    Re: Address label template how to.

    Post by [email protected] » Sat Dec 12, 2015 11:33 pm

    How to print address labels using openoffice

    Re: Address label template how to.

    Post by RoryOF » Sun Dec 13, 2015 12:38 am

    User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

    • Unanswered topics
    • Active topics
    • Search

    [Solved] Printing Stickers

    [Solved] Printing Stickers

    Post by gino_76ph » Mon Aug 18, 2008 7:05 pm

    How to print address labels using openoffice

    Re: Printing Stickers

    Post by Bhikkhu Pesala » Mon Aug 18, 2008 11:50 pm

    I deleted your duplicate post. One post per topic only, please.

    There is an option to choose labels when starting a new document.
    That is where you can select your Avery labels.

    How to print address labels using openoffice

    Re: Printing Stickers

    Post by TheGurkha » Tue Aug 19, 2008 12:06 am

    Re: Printing Stickers

    Post by JohnV » Tue Aug 19, 2008 1:59 am

    Mia Posts: 3 Joined: Tue Aug 12, 2008 6:43 am

    Re: Printing Stickers

    Mia » Tue Aug 19, 2008 5:49 am

    How to print address labels using openoffice

    Re: Printing Stickers

    Post by TheGurkha » Tue Aug 19, 2008 11:28 am

    There should be a printer icon on the toolbar, or go to File > Print.

    If there is no printer icon showing go to View > Toolbars and make sure Standard has a tick beside it.

    Re: Printing Stickers

    Post by gino_76ph » Tue Aug 19, 2008 12:50 pm

    How to print address labels using openoffice

    Re: Printing Stickers

    Post by TheGurkha » Tue Aug 19, 2008 4:36 pm

    Make sure you have the correct label selected, and ensure that you have set the printer settings etc to A4.

    I usually print on plain paper and then hold the sheet of labels and the printed page together against the light to check the alignment. Sometimes you need to fiddle with the font a bit to make it all work. when it is OK, I then print the labels.

    Re: Printing Stickers

    Post by gino_76ph » Tue Aug 19, 2008 5:00 pm

    TheGurkha wrote: Make sure you have the correct label selected, and ensure that you have set the printer settings etc to A4.

    I usually print on plain paper and then hold the sheet of labels and the printed page together against the light to check the alignment. Sometimes you need to fiddle with the font a bit to make it all work. when it is OK, I then print the labels.

    How to print address labels using openoffice

    Re: Printing Stickers

    Post by TheGurkha » Tue Aug 19, 2008 5:41 pm

    If you question has been answered please go to your first post and use the Edit button, and add [Solved] to the start of the title. You can also select the green tick icon.

    • Getting started
    • ↳ Survival guide
    • ↳ Beginners
    • ↳ Getting Started Guide for 3.x
    • ↳ Install, Setup and Troubleshooting
    • ↳ Admin Guide
    • ↳ MS Windows
    • ↳ Linux
    • ↳ Mac OSX
    • ↳ LibreOffice
    • ↳ Tutorials
    • ↳ Writer
    • ↳ Calc
    • ↳ Base
    • ↳ Database Examples
    • Applications
    • ↳ Writer
    • ↳ Writer Guide for 3.x
    • ↳ Writer Tutorials
    • ↳ Templates
    • ↳ Advanced Uses
    • ↳ Calc
    • ↳ Calc Guide for 3.x
    • ↳ Calc Functions
    • ↳ Calc Tutorials
    • ↳ Impress
    • ↳ Impress Guide for 3.x
    • ↳ Draw
    • ↳ Draw Guide for 3.x
    • ↳ Math
    • ↳ Math Guide for 3.x
    • ↳ Math Guide for 3.x
    • ↳ Base
    • ↳ Wiki
    • ↳ Base Tutorials
    • ↳ Tables & Queries
    • ↳ Forms
    • ↳ External Data Sources
    • ↳ Reporting
    • Customizing and Extending
    • ↳ Macros and UNO API
    • ↳ Basic Guide
    • ↳ OpenOffice Basic, Python, BeanShell, JavaScript
    • ↳ External Programs
    • ↳ UNO API and ODF
    • ↳ Code Snippets
    • ↳ Extension Repository
    • ↳ Macro Repository
    • ↳ Extensions
    • ↳ Extensions page
    • Community
    • ↳ General Discussion
    • ↳ Site Feedback
    • ↳ Forum Governance
    • ↳ User Experience (UX)
    • ↳ Announcements
    • Business
    • ↳ Institutions & Educational
    • ↳ Paid support
    • ↳ Consultants Directory
    • Board index
    • All times are UTC+02:00
    • Delete cookies
    • Contact us

    Powered by phpBB® Forum Software © phpBB Limited

    How to print address labels using openoffice

    How to print envelopes & mail merge

    Post by johncraw » Fri Jun 18, 2010 8:45 pm

    Every year we create Christmas cards. We use the same size card, and we place a picture on the envelope. In previous years, we have used Word for this. I want to start using Writer.
    So with that background these are my trials.
    I used Envelope from the Insert menu. I created the envelope got the data source, put the picture on the envelope, and looked at the results. Worked great! Except, blank address lines were displayed.
    So I thought to myself Self! why not use mail merge. This allows you to surpress blank lines in addresses. So I set up the document as an envelope. got the data source (a little frustrating there). Added the picture, and looked at the results. Worked great! Except the picture did not print.

    So I have two methods that do almost what I want. I could pre-print the picture and then print the addresses, but that seems like more work than it should be.

    I also read a description in the forum on how to surpress blank lines. However some of the responses seemed to indicate that it didn’t always work. So am I doing something wrong, or do I just pick the best option and go with it.

    I also have a problem editing a data source. Using Writer 2.3 I can create the data source (as .csv), add the values. I can also edit the source. However no changes are saved (either new or changed)

    I also tried a later version of Writer (not sure which level) and I can create a data source, but cannot edit it. Any suggestions.
    Thanks in advance
    John Crawford

    Title Edited. A descriptive title for posts helps others who are searching for solutions and increases your chances of a reply. (TheGurkha, Moderator)

    How to print address labels using openoffice

    Re: envelopes/mail merge

    Post by TheGurkha » Fri Jun 18, 2010 8:58 pm

    Much easier to create your data source in Calc, and either save as .csv from there or just save it as a spreadsheet (which is the easiest option, IMHO).

    Here’s a long page of all kinds of useful stuff to do with labels: Labels Tutorials, which also discusses mail merge, and is a really good resource.
    This is also useful: FSM Mail merge Tutorial

    Pages 15 – 17 of Chapter 11 of the Writer guide describe how to suppress blank lines: OOo 3 User Guides.

    You have to abandon thinking in a ‘Word’ way completely, because mail merge is so different in OOo. But once I got used to it I found it far more flexible and powerful.

    How to print address labels using openoffice

    Re: How to print envelopes & mail merge

    Post by johncraw » Sat Jun 19, 2010 1:59 am

    How to print address labels using openoffice

    Re: How to print envelopes & mail merge

    Post by TheGurkha » Sat Jun 19, 2010 12:46 pm

    Written by co-founder Kasper Langmann, Microsoft Office Specialist.

    Using Excel provides the ideal setting for storing and curating addresses for your mass mailing and labeling projects.

    Mass printing and sending of mails could be hard work especially if you don’t know how to mass print your labels in Excel.

    But we got your back on that. 😊

    In this article, we will provide you with an easy-to-follow step-by-step tutorial from creating and formatting to printing mailing labels using Excel.

    Table of Content

    How to make and print a mailing list

    Making and printing a mailing list is quite simple.

    But for beginners, it may feel a bit complicated especially with having to use two Microsoft apps, Excel and Word.

    Rest assured, it’s quite easy to do.

    There are 4 steps you have to take to print mailing labels in Excel:

    1. Prepare your worksheet
    2. Make sure you have the necessary data
    3. Mail Merging with Microsoft Word
    4. Finishing & Merge

    As a bonus, we also included a section where we’ll show you how to quickly add borders. With borders, cutting the labels becomes easier.

    Get your FREE exercise file

    Before you start:

    Throughout this guide, you need a data set to practice.

    I’ve included one for you (for free).

    Download it right below!

    Download the FREE Exercise File

    How to print address labels using openoffice

    Prepare your worksheet

    First things first:

    Set up your worksheet properly.

    Getting the right data is tantamount to success in printing mailing labels.

    Simply type the following in the first row of your spreadsheet (these are pretty much the regulars):

    • First Name
    • Last Name
    • Street Address
    • City
    • State
    • Zip Code

    It’s important that you write these in the first row of your worksheet and not on any other.

    How to print address labels using openoffice

    Make sure you have the necessary data

    Begin encoding the necessary data.

    Making sure they are accurate and correct should be your top priority at this phase.

    Avoid leaving blank cells in between as it may mess up with the merging later on.

    Since this is a mailing list, double-check your data.

    Go over it twice. Thrice. Check the spelling. Check the address.

    Things to look out for:

    1. Make your column name labels specific and clear. For example, “First Name”, “Last Name”, and “Address”.
    2. Separate information. Make it as specific as it can get. It’s not recommended to put the first name and last name in a column. It’s better to put them into separate columns.
    3. Don’t leave blank cells in between your data. An empty row may mislead Word when merging later on.

    How to print address labels using openoffice

    Once you’re confident that you have accurate information, save the workbook on your preferred location.

    Mail Merging with Microsoft Word

    Now, there will be a lot of back and forth on these next instructions.

    But don’t worry, we’ll make sure it will still be easy to follow.

    What you have to do next is open Microsoft Word on your computer.

    Then, create a new blank document .

    On the new document, click ‘Mailings’ from the tab list.

    How to print address labels using openoffice

    Click the ‘Start Mail Merge’ icon and select ‘Labels…’ .

    How to print address labels using openoffice

    A window titled ‘Label Options’ will open.

    On the ‘Label vendors’, select ‘Avery US Letter’ .

    On the ‘Product number’, select ‘5160 Address Labels’ .

    Press ‘OK’ .

    How to print address labels using openoffice

    We chose these settings since they are pretty standard and universal . But if you’re using a specific vendor and product number, feel free to use them instead.

    Now for the next step, click ‘Select Recipients’ from the Ribbon and choose ‘Use an Existing List…’ from the options.

    How to print address labels using openoffice

    After that, find and click the workbook you saved earlier.

    Once you find it, another window will open.

    Assuming you have no other active sheets on your workbook, press ‘OK’ .

    If not, select the sheet containing the mailing list.

    How to print address labels using openoffice

    Afterward, your word document will look similar to the one shown below:

    How to print address labels using openoffice

    Once you got that, make sure your cursor is on the upper-right corner of the document.

    Then, click ‘Address Block’ icon on the ‘Write & Insert Fields’ group on the Ribbon.

    On the ‘Insert Address Block’ window, click ‘Match Fields…’ found on the bottom-right corner.

    How to print address labels using openoffice

    What ‘Match Fields…’ does is that it links up with the Excel file you made and read the first row entries and match it up with fields required for the address block.

    Of course, check if the fields were matched.

    If not, click the dropdown button on one of the entries and match it up with a row heading on your Excel file.

    Press ‘OK’ once everything is ready.

    How to print address labels using openoffice

    You’ll get back to the previous window. Click ‘OK’ again.

    Warning message

    Primary tabs

    • View (active tab)
    • Releases

    How to print address labels using openoffice

    You can organize your important family dates and contact information with this database. It can produce a list of upcoming birthdays & anniversaries, print address labels, store miscellaneous family information. You can even export upcoming birthdays or contact information to Outlook CSV/ical format.

    Unzip or extract this download before use. On Windows, you will need to move the download out of the “tmp” folder, such as to your desktop.

    Family Address Book with Birthday Reminders

    Version Operating system Compatibility Release date
    4.0 System Independent 4.0 09/03/2014 – 23:53 More information Download
    4.0 System Independent 10/08/2013 – 23:14 More information Download
    4.0 System Independent 19/02/2013 – 22:57 More information Download
    3.9 System Independent 11/09/2012 – 10:53 More information Download
    3.8 System Independent 16/03/2012 – 15:07 More information Download
    2.7 System Independent 06/11/2010 – 19:41 More information Download
    2.6 System Independent 3.4 11/01/2010 – 18:17 More information Download
    2.4 System Independent 3.4 11/01/2010 – 14:34 More information Download
    2.3 System Independent 3.4 15/03/2009 – 10:24 More information Download
    System Independent 3.4 03/01/2009 – 22:19 More information Download
    System Independent 3.4 01/01/2009 – 18:22 More information Download
    System Independent 3.4 01/01/2009 – 12:58 More information Download
    System Independent 3.4 01/01/2009 – 12:56 More information Download
    System Independent 3.4 29/12/2008 – 08:53 More information Download

    I cannot manipulate the Family Address Book document without receiving a error message “No Java installation could be found”. I’ve uninstalled Java, removed older versions and reinstalled newest version, along with updating Open Office. Any suggestions from anyone?

    I just downloaded and began using this extension. So far I think it is great except for one thing. I really want it to filter the phone numbers I type in so that it automatically changes the numbers typed, 1234567890, to the correct format: (123)456-7890. I really don’t like have to type all the formatting every time. For this reason, I would look for another address book extension or even program.

    frkauffman
    By registering the database first, I was able to paste in the data.
    Thank you for the program.

    frkauffman
    I downloaded it but I can’t paste the Calc data into the Information Table. “Paste” does not appear after I right click as instructed.

    I installed this template and entered 14 family pages. The final results are great!

    This is a very useful application – well thought out and generally user friendly, except for two issues with buggy functions (or, possibly with my ignorance).

    I had some trouble with entering dates, but not quite as the previous user described.

    While using the “Browse All Information” Form to enter and edit data, I found that some of the previously entered birth date and anniversary dates occasionally change, as additional dates are entered on the same page. I can see no consistent pattern to these occurrences, and the changes appear to be random, except that only valid-looking (but wrong) dates are produced. It is possible to correct the errors by re-entering the correct dates, although this may again occasionally cause other dates to change. Once editing of the page is completed, however, the dates seem to remain stable.

    I am also confused by the lack of a “Save” function. After entering new data or making edits, I find that the “Save” button is grayed-out, and non-functional. Closing the file with the “File: Close” button sometimes seems to save the changes, and other times does not. Closing the program with the “X” button sometimes elicits a question “Data has changed. Do you wish to save your changes?”. After clicking “Yes”, the changes may or may not be saved. Changing to another page before closing makes no difference.

    I am puzzled by the caption bar “FamilyAddressBook.odb 1. Browse All Information (Read Only) – OpenOffice.org Base” . If it is truly “Read Only”, why does it allow me to edit at all, and eventually to save my edits?

    It seems that I must make only a few changes at a time, then close the file in hopes that my changes will be saved, before re-opening and continuing my edits. I adjusted the “Auto-Save” function to 2 minutes – this does not seem to guarantee that changes will be saved, although I wait more than the specified time after my last edit before closing the file.

    I am a newbie with the Open Office Base software, so I may well be missing something basic. I followed the set-up and use instructions cook-book fashion. I have searched the available documentation and read the forums about these issues.

    Apparently I am not alone in experiencing these kinds of problems, but none of the suggested solutions so far have helped.

    more like mom

    android pro audio

    marketplace tri cities

    1967 thunderbird for sale craigslist

    • nys pension calculator tier 5
    • bmp 1100 turbo

    disposable e cigs near me

    calcasieu parish arrest report

    jbl 136a specs

    fox 23 weather

    rx 570 multiple monitors best sbc starter

    How to print address labels using openoffice

    How to print address labels using openoffice

    How to print address labels using openoffice

    How to print address labels using openoffice

    • gabi and vivo lyrics
    • tdcj food menu
    • By streetwear brands
    • By rca 5ar4
    • By aws iam okta integration
    • By igcse physics workbook answer key
    • By new fleet vans for sale near virginia
    • usdt token address

    eve online csm 16

    • [RANDIMGLINK]
    • [RANDIMGLINK]
    • [RANDIMGLINK]
    • [RANDIMGLINK]
    • [RANDIMGLINK]
    • Tuesday, Jul 21 at 11AM EDT
    • Tuesday, Jul 21 at 12PM EDT
    • Tuesday, Jul 21 at 1PM EDT

    reddit monster hunter character creation

    • By gm block vin decoder and will my ex ever talk to me again reddit

    used dirt bikes for sale las vegas

    • By mac recovery keyboard not working
    • 1 hour ago

    2 man tent

    • By free pdf spiritual books

    how to make ableton piano sound good

    • By moss icon shirt

    lr308 piston

    • By olx pk islamabad

    farom games 2mb apk piur

    • By Sydney Page

    convert gis coordinates to gps

    petite studio coupon

    lenovo keyboard and touchpad not working

    craigslist egg harbor nj

    QuestConnect helps streamline your workflow and allows you to manage your Quest account online, at your convenience. You don’t need to pick up the phone. With QuestConnect, you can request test results, track a specimen, add & cancel tests, order supplies, find test information, make a payment and update your account information.

    wholesale candles no label

    clarke 100e mig welder no gas

    paymath cheat app

    eastdil secured virtual training program

    saddleseat suit pattern

    sanrio stationery wholesale

    type 2 diabetes, prediabetes, & weight management program resources care from anywhere—24/7 .