smtpMailerOOo logo smtpMailerOOo

Ce document en français.

The use of this software subjects you to our Terms Of Use and Data Protection Policy

version 0.0.2

Introduction:

smtpMailerOOo is part of a Suite of LibreOffice and/or OpenOffice extensions allowing to offer you innovative services in these office suites.
This extension allows you to send documents in LibreOffice / OpenOffice as an email, possibly by mail merge, to your telephone contacts.

Being free software I encourage you:

In short, to participate in the development of this extension.
Because it is together that we can make Free Software smarter.

Requirement:

smtpMailerOOo uses a local HsqlDB database version 2.5.1.
HsqlDB being a database written in Java, its use requires the installation and configuration in LibreOffice / OpenOffice of a JRE version 11 or later.
I recommend Adoptium as your Java installation source.

If you are using LibreOffice on Linux, then you are subject to bug 139538.
To work around the problem, please uninstall the packages:

If you still want to use the Embedded HsqlDB functionality provided by LibreOffice, then install the HsqlDBembeddedOOo extension.
OpenOffice and LibreOffice on Windows are not subject to this malfunction.

Installation:

It seems important that the file was not renamed when it was downloaded. If necessary, rename it before installing it.

Restart LibreOffice / OpenOffice after installation.

Use:

Introduction:

To be able to use the email merge feature using mailing lists, it is necessary to have a datasource with tables having the following columns:

In addition, this datasource must have at least one main table, including all the records that can be used during the email merge.

If you do not have such a data source then I invite you to install one of the following extensions:

This mode of use is made up of 3 sections:

Merging emails to mailing lists:

Requirement:

To be able to post emails to a mailing list, you must:

This Writer document can include merge fields (insertable by the command: Insert -> Field -> More fields -> Database -> Mail merge fields), this is even necessary if you want to be able to customize the content of the email.
These merge fields should only reference the main table of the data source.

Starting the mail merge wizard:

In LibreOffice / OpenOffice Writer document go to: Tools -> Add-Ons -> Sending emails -> Merge a document

smtpMailerOOo Merger screenshot 1

Data source selection:

The datasource load for the Email merging wizard should appear:

smtpMailerOOo Merger screenshot 2

The following screenshots use the gContactOOo extension as the data source. If you are using your own data source, it is necessary to adapt the settings in relation to it.

In the following screenshot, we can see that the data source gContactOOo is called: Addresses and that the main table: My Google contacts is selected.

smtpMailerOOo Merger screenshot 3

If no mailing list exists, you need to create one, by entering its name and validating with: ENTER or the Add button.

Make sure when creating the mailing list that the main table is always selected.

smtpMailerOOo Merger screenshot 4

Now that your new mailing list is available in the list, you need to select it.

And add the following columns:

If several columns of email addresses are selected, then the order becomes relevant since the email will be sent to the first available address.
In addition, on Recipients selection step of the wizard, in the Available recipients tab, only records with at least one email address column entered will be listed.
So make sure you have an address book with at least one of the email address columns entered.

smtpMailerOOo Merger screenshot 5

This setting is to be made only for new mailing lists.
You can now proceed to the next step.

Recipients selection:

Available recipients:

The recipients are selected using 2 buttons Add all and Add allowing respectively:

smtpMailerOOo Merger screenshot 6

Example of multiple selection:

smtpMailerOOo Merger screenshot 7

Selected recipients:

The recipients are deselected using 2 buttons Remove all and Remove allowing respectively:

smtpMailerOOo Merger screenshot 8

If you have selected at least 1 recipient, you can proceed to the next step.

Sending options selection:

If this is not already done, you must create a new sender using the Add button.

smtpMailerOOo Merger screenshot 9

The creation of the new sender is described in the Configure connection section.

The email must have a subject. It can be saved in the Writer document.

smtpMailerOOo Merger screenshot 10

The email may optionally have attached files. They can be saved in the Writer document.
The following screenshot shows 1 attached file which will be merged on the data source then converted to PDF format before being attached to the email.

smtpMailerOOo Merger screenshot 11

Make sure to always exit the wizard with the Finish button to confirm submitting the send jobs.
To submit mailing jobs, please follow the section Outgoing emails.

Configure connection:

Starting the connection wizard:

In LibreOffice / OpenOffice go to: Tools -> Add-Ons -> Sending emails -> Configure connection

smtpMailerOOo Ispdb screenshot 1

Account selection:

smtpMailerOOo Ispdb screenshot 2

Find the configuration:

smtpMailerOOo Ispdb screenshot 3

Show configuration:

smtpMailerOOo Ispdb screenshot 4

Connection test:

smtpMailerOOo Ispdb screenshot 5

smtpMailerOOo Ispdb screenshot 6

Always exit the wizard with the Finish button to save the connection settings.

Outgoing emails:

Starting the email spooler:

In LibreOffice / OpenOffice go to: Tools -> Add-Ons -> Sending emails -> Outgoing emails

smtpMailerOOo Spooler screenshot 1

List of outgoing emails:

Each send job has 3 different states:

smtpMailerOOo Spooler screenshot 2

The email spooler is stopped by default. It must be started with the Start / Stop button so that the pending emails are sent.

Spooler activity log:

When the email spooler is started, its activity can be viewed in the activity log.

smtpMailerOOo Spooler screenshot 3

Historical:

What has been done for version 0.0.1:

What has been done for version 0.0.2:

What remains to be done for version 0.0.2: