Writer 7.2: Mail Merge: form letter creation not working

When I try to follow the documentation example for Write 7.2 (installed), I do not get the option as available in the documentation.

Documentation states: “Display the registered data sources: View > Data Sources (or press Shift+Ctrl+F4).”

The menus do not have that option in Writer.

They keyboard shortcut is not working.

Please advise how do I connect and external (not Base) database to writer/calc to fill in forms.

Registering an Address Book

Mail Merge in Writer

Can that help?

What do you consider an external database?

Hello

To use Mail Merge with either Microsft SQL or MariaDB, the database must be registered in LO. To register it is done through a Base file. The Base file (only a front end to databases) need a connection to the chosen DB. For connections examples see the documentation → LibreOffice Base Guide

See Chapter 2 - Creating a Database

Microsft SQL, MariaDB

please note my words in the original statement:

Documentation states: “Display the registered data sources: View > Data Sources (or press Shift+Ctrl+F4).”

The menus do not have that option in Writer.

They keyboard shortcut is not working.

so I tried following the sweet manuals. problem is that they are not working as my app do not have the menu items as per the documentation

What OS are you using, Specific LO version and is entire LO installed or simple Write?

All should be installed

Fedora 35. Complete LO installed

Try safe mode (resetting user profile) → LibreOffice user profile
.
If no success and you have distro version installed, try TDF version → LibreOffice
.
If still an issue, file a bug report → Bugzilla

How to connect to MariaDB/MySQL…

  1. menu:File>New>Database…
    [X] Connect to existing database
    1a) Type: MySQL (uses a built-in LibreOffice driver for MySQL)
    1b) Type: JDBC (if you want to use a JDBC driver for MySQL)
    1c) Type: ODBC (if you already have configured ODBC)
  2. Specify the connection details.
  3. [X] Register database (so it appears in LibreOffice’s data source window)
  4. Save the database under some name. This “database document” contaiins only connection data.
  5. You may want to add some meaningful query for your mail merge task with joined tables, selected coluns, meaningful column names, filtering the relevant records.
1 Like