Mail merge in OpenOffice

I have tried some methods to make mail merge in OpenOffice but it failed and I think also that the step is too long.


This what I can do to make mail merge that works and very simple I think 

• Make sure that OpenOffice Database have been installed
• We have made two documents (main document in OpenOffice Word, second document in OpenOffice Spreadsheet) then Close and save our Spreadsheet document
• From OpenOffice Word, choose Insert - Fields - Other. Choose Database - Mail merge fields - Browse (choose our spreadsheet document)
• Then we will see our Spreadsheet file in Database selection
• Then double click our Spreadsheet file, Sheet, then choose which column you want to insert. Then click insert. We will find the link in our OpenOffice Word document and then close fields window.
• The last step we will combine the document. Still in OpenOffice Word, click Tools - Mail Merge Wizard - Next ... Next ... & Next again until at last step Save, print, or send.
• Then click Save merged documents - save as single document - Save Documents - Finish
  It also work when I do in LibreOffice.

How to Install Windows Fonts in Ubuntu?

Although we use linux and use OpenOffice or LibreOffice, some times we need windows fonts to some important things. Like Times New Roman, Arial, and the other windows fonts.

To do it, just open terminal then type,

sudo apt-get install msttcorefonts

Then restart your Office (OpenOffice or LibreOffice) / close and run again your office. Then you will see new fonts in your office.

Other way you can install windows fonts manually,

Copy windows fonts from windows (usually in C:\Windows\fonts directory)

Then paste to your Ubuntu (usually in File System – usr – share – fonts)

If you can not paste it, you can open your file manager (nautilus) from terminal

sudo nautilus

How to print F4 or Folio Landscape in Ubuntu

Some days ago when I was doing my job to print some documents with format of the paper is F4 or I call it Folio (height 33 cm) with the Position of the paper or the orientation is Landscape I get the result that my document is cut from right side. Usually its okay when I print in Portrait orientation but not when I print in Landscape.

When I try some experiment, Finally I get the solution that is just to edit the Format of the Paper.

First, I chose Format Paper use Legal (height 35.5 cm) and then I edit the margin of the paper, that is I add some centimeters from left margins about 2.5 cm (35.5 cm - 33 cm).

For example when I want to print with each margin 1 cm, then I edit the margin of my paper:

Left = 3.5 cm (2.5 cm + 1 cm)

Right = 1 cm

Top = 1 cm

Bottom = 1 cm

When I want to print with each margin 2 cm, I edit my paper:

Left = 4.5 cm (2.5 cm + 2 cm)

Right = 2 cm

Top = 2 cm

Bottom = 2 cm

Next I just add 2.5 cm from left margin.

Write Arabic in Ubuntu

To write many kinds of letter in Ubuntu we can set the key baoard layout and in Ubuntu is very complete we can write many kinds of letter not only Arabic.

To do that is just use Key board Indicator

1. Right click on panel chose Add to panel

2. Chose Keyboard Accessibility Status then click Add

3. Then in your panel there is new icon

4. Just click in new icon to chose new keyboard layout

5. Then chose your own layout

To switch from USA to Arabic just click keyboard picture in the panel. Now you can write in Arabic.