Login
Word, templates, rage
8 October 2021 at 17:44
This is with Word 2019 for Mac.
Why am I using Word, anyway? - because LibreOffice has stopped working with our membership database in SQLite, and wasnβt working at all well with a CSV export. Oh, and Word doesnβt work with SQLite either.
I managed to create a Word template by careful editing of the LibreOffice version; painful to have to work with CSVs, but better than filling in 100 membership letters by hand (most of our members have email, so a Python script using email.mime, smtplib, sqlite3 etc worked for them, leaving the diehards ...)
OK, the organisation has a new chair, time to update the template.
Where is it? Turns out, ~/Library/Group Containers/UBF8T346G9.Office/User Content/Templates. Well done, Microsoft.
And then, the challenge is to find a way of editing the template. Whatever I try, whatever tips I follow on the net, all I can do is edit a document based on the template, which is not what I need to happen!
I would look into PDFs viaΒ fpdf2, but I should only have another year in this post and the next person might have an issue with that. (The same applies to using SQLite, of course. Hmm.)
So I guess itβs back to LibreOffice.