Posted over 1 year ago. Visible to the public.

Form letters with LibreOffice Writer

This is painful. Consider using Microsoft Office or switching careers. If you need to write < 20 letters consider doing it manually.

So you didn't listen and here it comes:

  1. Ignore the Mail Merge Wizard. It will crash or destroy your document.
  2. Export your addresses, recipient names, etc. as a .ods spreadsheet (.xls, .xlsx, .ods). Use any columns that work for you, but be consistent. I like to use one column for the address, one column for the salutation line.
  3. Import the spreadsheet as an address book source: Tools => Address Book Source => Address Data Source… => Other external data source => Settings => Choose "Spreadsheet" as Database type => Next => Pick spreadsheet file => Ignore field assignments => Give it a name
  4. Back in your document you can now insert placeholders for a column value. Use menu Insert => Field => More fields… => Mail Merge Fields. Select the address book database you imported earlier. Pick the column you want. Insert.
  5. Print the document with File => Print. LibreOffice will ask you if you would like to print a form letter.

If Writer keeps crashing on the last step, recreate your letter template from a blank page like a wild animal. Be careful to paste text without formatting or styles.

Once an application no longer requires constant development, it needs periodic maintenance for stable and secure operation. makandra offers monthly maintenance contracts that let you focus on your business while we make sure the lights stay on.

Owner of this card:

Henning Koch
Last edit:
over 1 year ago
by Henning Koch
About this deck:
We are makandra and do test-driven, agile Ruby on Rails software development.
License for source code
Posted by Henning Koch to makandra dev
This website uses cookies to improve usability and analyze traffic.
Accept or learn more