Mail Merge

📮 Mail Merge — Paper 4 Task Technique (W23, W24, W25)

The 4-step process:

1. Create the database — Open LibreOffice Base → new database → create table in Design View → add fields with correct data types → enter data from ODS spreadsheet → save table as "Accounts" → save database as F2uF_Accounts_ZZ999_9999
2. Open the RTF template — Open F2uF.rtf in LibreOffice Writer → Tools → Mail Merge Wizard → connect to your F2uF_Accounts database
3. Insert merge fields — Insert → Field → More Fields → Database tab → select database fields for name, address etc. For conditional text (Paid/Unpaid): Insert → Field → More Fields → Functions tab → "If" → enter condition (Mar_Paid EQ 0) → Then text (unpaid message) → Else text (paid message)
4. Run filtered merges:
   • MarchLetters: filter Mar_Paid = FALSE → 5 letters → save as MarchLetters_ZZ999_9999.odt
   • April300Letters: filter April_Owed > 300 → 4 letters → save as April300Letters_ZZ999_9999.odt

⚠️ Critical facts for W23 mail merge:

• 5 customers with unpaid March bills: BHar (£63.04), EBla (£132.34), GWoo (£54.94), RCoo (£27.45), TWin (£56.74)
• 4 customers with April bill > £300: ECha (£336.15), FWal (£300.05), NBar (£427.20), SBuc (£355.95)