Read more

Form letters with LibreOffice Writer

Henning Koch
December 14, 2017Software engineer at makandra GmbH

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

Illustration online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
Read more Show archive.org snapshot

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.

Posted by Henning Koch to makandra dev (2017-12-14 15:39)