Writer mail-merge to PDF with editable fields

Hello all,
My goal is to create ‘membership cards’ (PDF documents) that can be mailed to members of a small non-profit organisation, so that they can check their personal data (address, phone, mail, …) and when appropriate make changes and send the document back to update the member registry (calc file).

I can make a mail-merge writer doc with data source fields in de document and do a mail-merge to individual pdf documents (1 per data source row), however the data source fields values behave like ‘fixed text’, i.e. not editable in the PDF.

I can make a writer doc with text form fields whose content becomes editable in most PDF viewers.
I can even tie the text form fields to the same data source as the one for mail-merge.

However, after doing this there are 2 record navigators in writer: one in the top menu bar that controls the mail-merge navigation and one at the bottom of the window that controls the form navigation and the issue is that they operate independently !

So when in Writer I go to the next source row for mail-merge (top) the mail-merge fields are updated, but then I also have to position the form navigator (bottom) to the same record number to update the form fields …

When doing the mail-merge (to individual PDF’s) the ‘fixed’ fields change as the merge loops through the data source, but the form fields stay positioned on record 1, so each PDF has the fixed content of the corresponding source row but the editable fields of the first row.

I’ve looked all over but found no solution to “tie” the form navigator to the mail-merge navigator (so that the form navigator positions himself to the same record of the mail-merge navigator after this one changes).

I assume that some kind of macro coding might make this happen, but I found nothing on the web to put me in the right direction …

Anyone got some idea ? If required I can produce sample files (writer & calc), but this will take some time as now I’m ‘experimenting’ on a copy of live data.

Thanks !

Sample data is in a zip that is available here : Box link

My LO version is 7.3.7.2 / Libreoffice Community on Linux Mint 21.2 x86_64, kernel 5.15.0-83-generic

1 Like