https://bugs.documentfoundation.org/show_bug.cgi?id=105071
Bug ID: 105071
Summary: MailMerge: when running e-mail using a macro NO
messages get sent
Product: LibreOffice
Version: 5.4.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
In Writer when attempting to email messages using a macro NONE get sent. This
occurs when trying to send emails through either smtp.gmail.com or a smtp
server running on localhost.
This problem started to occur with commit
e3e2a4a2d18b567f0add7cfcdede7b0c4cffbece. I've attached a bisect log for
inspection.
In testing running with a smtp server on localhost avoids upsetting your email
provider. When testing on localhost I use "python -m smtpd -n -c
DebuggingServer localhost:587 2>&1 | tee /tmp/smtpd.log" running in background,
I've only ever managed running this server as root.
Steps to reproduce the problem.
1.
Download the files CompanySeedStarted1.odt and CompanySeedTestData1.odb from
this bug report. The database CompanySeedTestData1.odb contains 63 entries all
with dummy email addresses.
2.
Start LibreOffice writer with the document CompanySeedStarted1.odt downloaded
in step 1. Note: this file contains a macro so be mindful that some security
steps might need to be taken.
3.
Tools -> Mail Merge Wizard
4.
The "Select starting document" dialog box should appear. The left pane should
contain 5 steps. In the right pane select the "Use Current Document" Radio
Button. Then press the "Next >>" Button.
5.
The "Select document type" dialog box should appear. Select the "E-mail
message" Radio Button. Then press the "Next" Button.
6.
The "Insert address block" dialog box should appear. Press the "Select
Different Address List" Button.
7.
The "Select Address List" dialog box should appear. Press the "Add" Button.
8.
The "Open - LibreOffice" dialog should appear. Navigate to directory containing
CompanySeedTestData1.odb downloaded in step 1. Once the database has been
selected press the "Open" Button.
9.
The "Select Address List" dialog box should re-appear with the database
CompanySeedTestData1 and the table tblCompanySeedTestData1 added to the list of
available databases. If not already selected - select this database. Press the
"OK" Button.
10.
Control should be returned to the "Mail Merge Wizard" dialog. Press the
"Finish" Button.
11.
If not already done so. Establish the Mail Merge E-mail settings by navigating
from the menu Tools -> Options -> LibreOffice Writer -> Mail Merge E-Mail
11.1
The "Options LibreOffice Writer Mail Merge E-Mail" dialog should appear. Enter
the senders name you want to be called by, the senders email address, the
server name, the port number. If not already checked left click the "Use secure
connection (SSL) check box. Push the "Server Authentification" Button.
11.2
The "Server Authentification" dialog should appear. Enter the senders email
address and the senders password for the smtp server. Push the "OK" button.
11.3
Control will be passed back to the "Options LibreOffice Writer Mail Merge
E-Mail" dialog. Push the OK Button. Control will return to the open document.
12.
Run the MailMerge macro by navigating from the menu Tools -> Macros - Run
Macro.
13.
The "Macro Selector" dialog should appear.
14.
In the left hand "Library" pane navigate to the macro CompanyStarted1.odt ->
Standard -> CompanyStarted1
15.
In the right hand "Macro Name" pane select the macro "Email_Test_0001". Press
the "Run" button".
16.
Control should be passed back to the document. Progress will be indicated by
the progress bar in the status area. Should process 63 of 63 messages. A "Done"
message box should appear.
17.
Though the Mail Merge process indicates that 63 messages have been processed
NONE appear on the server configured in the "Mail Merge E-mail settings"
dialog.
18.
When running LibreOffice 5.1.5.2 all 63 messages appear when the "Mail Merge
E-mail settings" are configured for localhost. Because of tdf#103919 only a few
messages appeared when the "Mail Merge E-mail settings" was configured for
smtp.gmail.com
Alex
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
