How to print envelopes using OpenOffice?

Printing envelopes involves two steps: setup and printing.

To set up an envelope to be printed by itself or with your document:

Envelope dialog box
Choosing addressee and sender information for an envelope.

Envelope format
Choosing position and size of envelope elements.

Envelope printer
Choosing printer options for an envelope.

  1. Click Insert > Envelope from the menu bar.
  2. In the Envelope dialog box, start with the Envelope tab. Verify, add, or edit the information in the Addressee and Sender boxes (the “from" on the envelope). You can use the right-hand drop-down lists to select the database or table from which you can draw the envelope information, if desired. 
  3. On the Format page, verify or edit the positioning of the addressee and the sender information. The preview area on the lower right shows the effect of your positioning choices.
  4. To format the text of these blocks, click the Edit buttons to the right. In the drop-down list you have two choices: Character and Paragraph.
    • In Character, you can choose Fonts (Sizes…), Fonts Effects (Underlining, Color…), Position (Rotating/scaling…), Hyperlink, Background and more.
    • In Paragraph, you can choose Indents & Spacing, Alignment, Text Flow, Tabs, Drop Caps, Borders and Backgrounds.
  5. In the lower left of this page, choose the envelope format from the drop-down list. The width and height of the selected envelope then show in the boxes below the selected format. If you chose a pre-existing format, just verify these sizes. If you chose User defined in the Format list, then you can edit the sizes.
  6. After formatting, go to the Printer page to choose printer options such as envelope orientation and shifting. You may need to experiment a bit to see what works best for your printer. You can also choose a different printer or alter printer setup (for example, specify the tray that holds envelopes) for this print job.
  7. When you have finished formatting and are ready to print, click either the New Doc or Insert button to finish.
    • New Doc makes only an envelope or starts a new document with the envelope. Insert inserts the envelope into your existing document as page 1.
    • To not proceed with this envelope, 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.
  8. When the Envelope dialog box closes, you are returned to your document, which now has the envelope in the same file as the document. Save this file before you do anything else.

To print the envelope:

  1. Choose File > Print from the menu bar.
  2. On the Print dialog box, under Print range, choose Pages and type 1 in the box. Click OK to print.

Setting up envelope details from a database

You can use a database as a source of name and address details for printing one or a series of envelopes, either alone or with accompanying letters. Mozilla address books, dBase databases, spreadsheets, databases created by OOo Base, and others can be used as data sources.

After you have set up a data source, you need to register it with OOo so OOo can access it. To register a data source, select File > New > Database, select Connect to an existing database, and select the type of data source to connect to. The exact source can then be chosen in the wizard.

To use the database when printing envelopes:

Select database fields
Choosing a database and table from which to use addressee details.

Database fields for envelope
The Envelope dialog box after choosing database fields for Addressee.

Confirm merge
Confirmation dialog box for merging database fields.

Mail Merge dialog box
Choosing records to use when printing envelopes.

  1. Click Insert > Envelope from the menu bar.
  2. On the Envelope dialog box, select from the Database list the name of the data source. In the Table list, select the database table or sheet containing the address data that you want to insert. The Database field list will now show a list of the fields in the selected database.
  3. Select the field containing the first piece of data (for example, First name) that you want to insert, then click the left arrow button to add the data to the Addressee box.
  4. To put another field on the same line in the Addressee box, select that field and click the left arrow button again. Be sure to include punctuation or spaces between fields in the Addressee box as needed.
  5. To put a field (for example, the address) on a new line, press Enter at the end of the previous line in the Addressee box. When you are finished selecting fields, the Envelope dialog box will look something like the figure below.
  6. Click Insert or New Doc. A formatted envelope is now visible in your document.
  7. Click File > Print from the menu bar. The dialog box shown below appears. Click Yes.
  8. The Mail Merge dialog box appears. Here you can choose to print envelopes addressed to one, several or all address records in the database. 
  9. Make your selections and then click OK to begin printing.


Thunderbird Tutorial – How to import Outlook email / address book to Thunderbird??

  1. From the main Thunderbird window click on Tools and thenImport…

  2. Click on the Address Books radio button, then click on Next

  3. Click on Outlook and then click on Next

  4. If you get this error messages, you will need to launch Outlook and click on Yes when it asks if you want to set it as the default mail client. Go back step 3 and try again.

  5. If all went well , it will tell you that it was able to import the contacts successfully. Click on Finish to go back to the main Thunderbird window.

  6. Click on Address Book to view the imported contact information.

  7. There is now a new list called Contacts and in this list there are your Outlook contacts and distribution lists. Close this window to go back to the main Thunderbird window.

  8. To import email, click on Tools and the Import…

  9. Click on the Mail radio button and then click on Next

  10. Click on Outlook and then click on Next

  11. This will show a summary of all the messages that were imported. Click on Finish to go back to the mainThunderbird window.

  12. In the folder list on the left hand side there is now a Outlook Mail folder. In this folder you will find your imported messages.

This concludes the migration of setting from Microsoft Outlook

Open Office Writer – Mailing Labels and Return Address Labels


In this tutorial, we will make a sheet of labels. All the labels on the sheet will have the same name and address. The sheet of labels will be printed. The file with the labels will be saved so the labels can be printed again.

There may be times that you do not need a whole sheet of labels so we will make and print a single label.


Open A New Text Document

  1. IF on the desktop, click  > All Programs > 2.3 > Writer.
  2. IF you are in Writer, click File > New > Text Document.
  3. In either case, the text document  appears on our screen.

Check Settings On The Ruler

  1. IF you see a Ruler on your screen, go to Step 4.

  2. IF you cannot see a Ruler on your screen, click View. (A dialog box appears in which there is no check-mark before the word Ruler.)

  3. Click Ruler. (the window closes and the Ruler appears on your screen)

  4. If you are not already using Centimeter instead of Inch, change to Centimeters. (There is just enough difference to make it difficult to fit the the addresses into the labels.) To change to Centimeter, right click on the Ruler in your document. (A dialog box appears which has the word “Centimeter”.)

  • IF there is a check-mark before Centimeter, click anywhere outside of the dialog box (The dialog box closes) .

  • IF there is not a check-mark before Centimeter, click on Centimeter. (The dialog box closes)

Create An Entire Page Of Labels

  1. Click File > New > Labels. (The Labels window appears.)

  1. Click the Labels tab.
  2. Under the words Label text, there is a box where you will type the address that will be printed on the labels.
  3. Click within the box (The cursor moves to the upper left corner of the box) Type John Dow then press Enter. (The cursor moves down to the second line) Type 111 First Street on the second line. Type Anywhere on the third line. Type USA on the next line and 11111 on the next line. You may use any address of your choice.

  1. Under Format, select Sheet.
  2. In the pull-down menu to the right of Brand, click on the  to select the brand of labels that you use. For this tutorial, we will use Avery Letter Size.
  3. In the pull-down menu to the right of Type, click on the  to select the number corresponding to the brand that you use. For this tutorial, we will use 5260 Addresses.
  4. Click the Options tab. Check Entire page and Synchronize contents. When Synchronize contents is checked, only one (the top left label) has to be entered and edited while the remainder will be repeated identically.

  1. At the bottom of the page, click New Document. (A page of labels with the name and address that you entered will appear.) A small window appears with the “Synchronize contents” , , button

Center The Name and Address And Add A Space At The Top Of The Label

  1. Click in the first label. On the Formatting Toolbar, click the Centered, icon. (The name and address is centered on the label.).
  2. Click before the first letter of the name . Press Enter to add a space at the top of the label. (Since we checked “Synchronize contents”, we only have to enter and edit the one top left label).
  3. Press the Synchronize contents button. (All the names and addresses on the labels become centered with a space at the top)

Print A Sheet Of Labels

  1. Place a sheet of blank labels in the printer.
  2. Click File > Print.

Save File With Sheet Of Labels

  1. Click File > Save AsIn the Save in: pull-down menu box, click My Documents if it is not already selected. In the Save as type: pull-down menu box, click OpenDocument Text (.odt) if it is not already selected.
  2. In the File name: dialog box give the file a name that will help you remember the labels. For this tutorial, use John Doe Labels.
  3. Click Save. (The file is saved.)
  4. Click File > Close. (The file is no longer on the screen.)

Create A Single Label

  1. Click File > New > Labels. (The Labels window appears.)

  1. Click the Labels tab.
  2. Under the words, Label text, there is a box where you will type the address that will be printed on the label.
  3. Click within the box (The cursor moves to the upper left corner of the box) Type John Dow then press Enter. (The cursor moves down to the second line) Type 111 First Street on the second line. Type Anywhere on the third line. Type USA on the next line and 11111 on the next line. You may use any address of your choice.

  1. Under Format, select Sheet.
  2. In the pull-down menu to the right of Brand, click on the  to select the brand of labels that you use. For this tutorial, we will use Avery Letter Size.
  3. In the pull-down menu to the right of Type, click on the  to select the number corresponding to the brand that you use. For this tutorial we will use 5260 Addresses.
  4. Click the Options tab. Select Single label.
  5. If you are using a sheet of label with some labels missing, you will need to select the row and column of the label that will be printed. For this tutorial, we will print the label on the first row in the second column of labels. In the dialog box to the right of Column, Click on the  to select 2, . In the dialog box to the right of Row, click on the  to select 1.

  1. At the bottom of the page, click New Document. (The single label will appear on the page in row 1 in the second column.)

Print A Single Label

Click File > Print > OK. (The “Print” window opens. A single label is printed.)



Reuse File With Sheet Of Labels

  1. Click File > Open. (The 「Open」 window appears. If “My Documents” is not already in the Look in: dialog box at the top of the “Open” window, in the list of directories below the Look in: box, click “My Documents”. The words, “My Documents”, appear in the “Look in:” dialog box.)
  2. Click on the name that you gave the file of the labels in the list below the Look in: dialog box. (The name of the file, appears in the 「File name:」 dialog box.)
  3. Click the Open button which is to the right of the File name: dialog box. (The top line on the screen changes to the name of the file and the first page of the file, appears on the screen below the ruler.) You can print or edit the file if you want to do so.

Thunderbird – Setup Gmail support and Google calendar with Thunderbird

This tutorial will show you How to configure Thunderbird’s calendar feature (Lighting Plugin) to connect to your Google Calendar.

Before you follow this tutorial. Please make sure you have install Lighting Plugin for Thunderbird.  If you haven’t done that. Please refer to this tutorial.


Step 1. Start Thunderbird and switch to calendar view.

Right click below the Clendar area. You should see a menu come up as following screen shot.

Choose “New Calendar”


Step 2.  Choose “on the network” and click Next.


Step 3. Now we have to find you Google Calendar’s address.

Please open a browser (either Internet Explore or Firefox).

Now we have to login to your Google Calendar page.

Make sure you have select the calendar that you want to connect to.

Click on the triangle to show a drop-down menu as following screen shot.

Click “Calendar settings” which will bring you to next Step.



Step 4.  Now we have to find the “Private Address” for your Google Calendar.

This Private Address allow Thunderbird access to your Calendar with “read & write” privilege.

Scroll down to “Private Address” section,  Right click on “iCal” and choose “Copy Link Location”


Step 5.  Switch back to Thunderbird. Now you should see a window asking for your iCalendar location.

Paste the copied address to the Location box.



Step 6. Make sure that your address are paste into the Location box as below.

Click Next.


Step 7. This Window allow you to setup a “Alias name”  for the Google Calendar that you are connecting to. Also you can choose which color it should display with. This is very useful if you are connecting to multiple calendar. Setting the preferred color for your convenience.

Click next after you are done.


Step 8.  Click Finish.


Step 9. Now you can see Thunderbird is displaying all calendar events from your Google calendar.



This concludes the tutorial of Setup Google calendar with Thunderbird.

Thunderbird – Setup Lighting plugin for Thunderbird

Please note that Thunderbird plus lighting is only come with OpenOffice 2012 Pro and OpenOffice v4 Pro edition.

Lighting Plugin will provide you the Calendar feature. You can also configure lighting plugin to access Google Calender.

Here is a list of steps to install "Lighting plugin" within Thunderbird.

We are going to walk you through from inserting the disc to install thunderbird, to configure your email account and finally to install Lighting plugin.


Step1.   Insert the software disc to your DVD reader / burner.  The autorun menu should kick in. A browser windows should pop-up on your desktop as the screenshot below.


If you do not see this AUTORUN menu popup.

Please goto "MyComputer".  Browser to your DVD reader where you should see a file named "index.html".

Double Click on this file. You should see a browser window open as the screen shot above.

Following screen shots show you how to find the "index.html" file.





Step 2.  Navigate through the menu. Go to Installation tab.


Step 3. After click on the link to open file folder, you should see a screen as below.



Step 4. Double click on Thunderbird Setup 10.0.2 to run it.

If you do this right, you should see following screen. The setup window will pop up and waiting for your instruction.

Step 5.  Click next to keep going with installation.


Step 6.  When Thunderbird finishes install you should see this window.


Step 7. Set you email account.

After you click the finish button. You should see next window show up.

Now  we can process to the step to setup your email account.


Step 8. Enter you email account information.

Make sure that you enter your "email address" and "password" correctly. Click "continue" the setup will try to detect your mail server settings.


Step 9. 

In This window. It shows the server address it detects from previous "email address" you have entered.

Thunderbird did a pretty good job on detecting google gmail server setting.  It automatically detect that gmail support "IMAP" and "POP3" methods to access your email.

The difference between IMAP and POP3 is that when choose IMAP, Thunderbird will leave copies of emails on google's server.

While in POP3 mode, thunderbird will remove emails from the server after it download emails.


Step 10.

If all settings were correct. You should now see Thunderbird has display all your emails with folder structures at the left navigation panel.

All your emails are listing at right panel.



Step 11.   Now Let's install Lighting Plugin to enable calendar feature.

Go go menu command "Tools"  choose "Add-ons"


Step 12.

After choose "addons" in previous step. It will bring you to this window.


 Step 13. Click on the setting button it will show you a drop-down menu.  Choose "install add-on from file". Please refer to following screen shot.


Step 14.   You will see window pop up. Browse to your dvd reader and choose the folder – "files".



Step 15.

Find the file name "lighting-1.2.1-sm+tb-windows.xpi" and double click on it.


Step 16.  Now you will see a window pop up to confirm with you action.  Click install Now


Step 17.  After Thunderbird install the plugin it will ask you to restart the program.

Check the screen shot below.  Click on "Restart".


 Step 18.

After Thunderbird retart. You should see the calendar feature is active.

You can switch the view style between "Day, Week, Month"



This concludes setup lighting plugin for Thunderbird.

For any question. Please feel free to contact us.

Open Office Math FAQ

  • Is Math compatible with the equation editor of Microsoft Word?
  • How do I change the fonts used in my formula?
  • How do I number my equations?
  • How do I align my equations at the equality sign?
  • I need a symbol that Math does not provide. What can I do?
  • How can I get a left bracket without a right bracket?
  • How do I change the font of a subformula?
  • How do I change the spacing around my formula?
  • How do I change the color of a subformula?
  • How do I change the size of a subformula?
  • The fractions are too large for inline formulas. How can I make them smaller?
  • How do I typeset functions, such as max, det, that Math does not know about?
  • Can I find all the constructions of Math in the selection window?
  • How can I start the equation editor as an individual application rather than within Writer?
  • I have written a document containing a formula. I gave it to a friend and when she opened it the user-defined symbols didn’t work. What’s the matter?
  • I have inserted a formula in a HTML document and now I cannot edit it. Why not?
  • Why are my formulas jumping up and down on the textline?

Continue reading

Open Office Draw FAQ

  • Does OpenOffice have an equivalent to Word’s ‘WordArt’?
  • How do I crop an image in my drawing?
  • I want to change the size of an image inserted in a drawing document. How can I do this?
  • How do I export part of a drawing to EPS?
  • How can I save a Draw document into a standard file format (BMP, JPG, …)?
  • Where can I get more information on Draw?
  • I’d like to create a CD cover, but I’m not able to rotate the text so that it is readable on the side of the CD. What is the procedure for this action?
  • I have a JPEG image that needs its colors changed before I use it in an file. How do I change the colors?
  • Are there any extra tools for Draw?
  • I’m trying to print a Draw document, but the colors printed by my printer are not the same ones displayed on the screen. How can I edit them using the CMYK color system?
  • I am creating an organization chart. How do I evenly space my boxes?
  • I want a background of a dotted grid as a guide for my drawings. Is this available in
  • How do I insert a screen shot or other image into my drawing document?
  • When I print a Draw document, the drawings near the top or bottom page borders are not printed properly. How can I overcome this problem?
  • How can I redefine the origin of the drawing coordinates?
  • I have received a file that has graphics in it but all that shows up are the anchor symbols for the graphics. What’s wrong?
  • I’m drawing a web banner. How can I do it using a ‘Websafe’ color palette?
  • What do I do when word wrap and other formatting functions are dimmed (disabled) for text in shapes?

Continue reading

OpenOffice Impress FAQ

  • I inserted a song in my presentation, but when I change slide the music stops. How do I play music throughout a presentation?
  • How do I create my own presentation template?
  • Can I do the ‘loop until escape’ function in Impress?
  • How do I print the notes with the slides on the same page in Presentation?
  • How do I create header or footer information in an presentation? I want my information to show up on every slide.
  • How do I add Text Effects to a Text Box?
  • How do I print 2 slides per page from Presentation (one above the other)?
  • I have a MSOffice PowerPoint 97 .PPZ file produced using the ‘Pack and Go’ SaveAs feature. Can this file be opened in Presentation?
  • How can I redock the slide pane
  • I am numbering my slides, but I don’t want the page or slide number to show up on the title slide. Is this possible?
  • How do I insert more than one background into a presentation?
  • I would like to have both landscape and portrait slides in my presentation. Is this possible?
  • When I cut and paste text to Presentation, it pastes the text in a different size than the original. How do I maintain the text appearance?
  • I have a presentation with light text on a black background. When I print it, I’d like to have black text on a white background. Is this possible?
  • I am trying to export a presentation to HTML. I am getting an error message that says Nonexistent object. Nonexistent file. What’s wrong?
  • How can I create new styles?
  • How do I find and use the Sun slide presenter add-on, now that it has been loaded?
  • How do I take one slide from a presentation and put it into another presentation?
  • How do I modify the format of a date field in Presentation?
  • How do I pause a slide show and how can I queue a slide?

Continue reading

OpenOffice Calc FAQ – Formatting Spreadsheets

  • How can I create a drop-down list that references a list of values to select from?
  • How do I insert superscript or subscript text in my spreadsheet?
  • How do I wrap text within a cell in my spreadsheet?
  • How can I use a dot (.) as decimal sign instead of a comma?
  • How can I use conditional formatting?
  • How can links to other workbooks, including vlookups, update dynamically?
  • How do I add additional strings or characters to cell contents?
  • How do I insert a page number in the form of ‘Page 1 of N’ on each page of a spreadsheet?
  • How are thick lines or borders created around my cells?
  • How do I format cells in Calc so that the rows number automatically?
  • Is there a way to add times that total greater than 24 hrs?
  • How can I create my own sort lists?
  • How do I make a wide title cell extend across several columns in my spreadsheet?
  • I have a custom number format that I use, but Calc forgets it.
  • Some of the rows or columns in my spreadsheet are hidden. How do I see all rows or columns?
  • How do I disable the capitalized letter at the beginning of cells in Calc?
  • How do I rotate a column title so that it fits above my very narrow column?
  • How are notes within cells displayed?
  • Why are my notes not showing for cells?

Continue reading

Calc FAQ – Miscellaneous questions

  • What’s the maximum number of rows and cells for a spreadsheet file?
  • How do I protect cells in my spreadsheet?
  • How can I delete cell contents immediately with the backspace key like in Excel?
  • How to make a checkbox change according to data in another cell?
  • How can I rename a sheet?
  • How I change the order of sheets in my spreadsheet?
  • How can I see the row and column captions as I scroll through a sheet that is larger than my display?
  • How can I create a spreadsheet that is right-to-left oriented?
  • How is a variable date inserted into a spreadsheet cell?
  • I want to select two cells that are not adjacent, but holding down the CTRL key does not seem to work. How can I perform this action?
  • What is the fastest way to copy a calculation to all rows?
  • How can I start Calc instead of Writer?
  • How can I use cells from different Calc files?

Continue reading