Inf / Office

libre office

  • calc => spreadsheet ==> examples
  • tools → options
    • → libreOffice → advanced → enable macro recording
    • → libreOffice calc
      • → calculate → iterative references itertations
      • → generaral → input settings → update references when sorting

mail merge

mailmerge works differently in libreOfficeWrite and thunderbird!

  • libreOfficeWrite
    • source: csv, sheet of ods, any other data source
      • (edit → exchange database ==> select inuse and available sheet and click define to replace old table with new one! only by this method old - possible missing - tables can be removed
      • to add new sheet use libre office base and create db from xls
      • calc sheets are transformed in a DB (in ~Documents/....odb or where you select)
      • format money fields as text, right justified and add two digits ==> =TEXT(D2;"#'##0.00")
      • make fields index and filename ="beitrag20suppDank" &A2
    • insert field → more fields → database → mail merge fields → expand columns of table
      • conditional fields with fields ... functions
    • file &raff; print... accept mail merge, select to file and single file and pdf .... (with tools mail merge wizard: this document, select csv (again !?) no addressblock etc, finish ⇒ generation options appear on top of document)
    • to create pdf use: save merged → save as individual docs &arr; give a filename ...pdf (attention name depends on existing pdf in directory!!!!)
  • thunderBird
    • source: spreadsheet or addressbook, directly without intermediat DB
    • fields with {{Vorname}} syntax, conditional text with {{fm|F|Frau|Herr}} means if field fm contains "F" then "Frau" else "Herr"
    • in receiver put field (e.g. {{email}}) an then use tab, without tab it will complain about missing/illegal address
    • use file → mail merge
    • enter csv, attachements (with fields! use a column filename for pdf's generate with libreOffice mail merge!)
      • attention, interface got worse: all attachements must be select by the browse button and additionally, the field {{fn}} written in the textbox (without path, but with extension!)
    • send later (will put prepared mails in outbox, where you can check and send them