LibreOffice Writer: Remove database that is in use

Hi.

I have odt file which has Merge Mail function.
It’s kind of template which I need to distribute, and I have a small problem.
I want this template to don’t have any database connection.
By database I am ods files.

Exmaple file:
some_template.odt (21.2 KB)

Anyone have idea how to do this or is it even possible?
Thanks for help!

Hi.
I don’t want to change database.
I want to completely remove it.

Remove the database fields.

Doesn’t removing it from Options|Base|Databases work for you?

1 Like

When I open his file, I don’t have the same registered database. The mail merge fields refer to a void database. This can be redirected via Edit>Exchange Database…
After you did so, the mail merge fields switch from
<Old_Database.Old_Name.ColumnName>
to
<New_Database.New_Name.ColumnName>
In that dialog you can change the database and the query name but not each individual column name. This is not a problem if you know how to work with queries and alias names. I use queries with alias names to allow quick changes from one letter source to a completely different one.

However, the name of the old (non-existent) database and its table/query remains sticky somewhere in the document. It appears in the “Exchange Database” dialog after reloading the modified document. But it does not harm because the entry has no accessible child elements.