Prepare two files

  • Data source: a sheet whose first row holds field names (name, role, date…);
  • Main document: the letter template with placeholders.

Steps

  1. In Writer, choose References → Mail Merge;
  2. Pick the spreadsheet data source and the worksheet;
  3. Insert merge fields such as Name and Role;
  4. Preview, then merge to a new document or send by email.

Common issues

Lost number formats: set the column to Text. Dates shown as serial numbers: pre-format them with the TEXT function or a format switch.