Mailmerge not work

[Mex]

Hi, when I try to send email with mail merge, I obtain the error message that you can see after my signature.

I tried with several email account, with no luck. I’m using LibreOffice Version: 6.2.8.2 Build ID: 6.2.8.2-2.fc30.

I’m sure that I have set the username and password correctly. What is weird, is that the “test setting” button says that settings are ok, even if it remains hang on:

What is wrong?

If the “test settings” says that it is ok, why I get “authetication required” error?

Thanks
M

<class ‘smtplib.SMTPSenderRefused’>: (550, b’Authentication Required [smtp-33.iol.local; LIB_401]’, ‘<my_email_address>’), traceback follows
File “/usr/lib64/libreoffice/program/mailmerge.py”, line 288, in sendMailMessage
self.server.sendmail(sendermail, truerecipients, msg.as_string())
File “/usr/lib64/python3.7/smtplib.py”, line 867, in sendmail
raise SMTPSenderRefused(code, resp, from_addr)

[anon73440385]

Don’t rely on the test. It doesn’t test authentication (it seems to even not test the smtp port) and finally it cannot test whether your provider allows mass mails via SMTP at all and other providers have restrictions on the sending machine’s hostname being a FQDN (checked on a firewall or MTA level of the SMTP server and both far beyond what the test can do).

[Mex]

Thanks for your reply.

The test on the port seems to work: I change it on purpose, and I got an error on “test” button.

For test purpose, I’ve tried to send 3 email by mail merge but I’ve got that error, so it is not matter of mass mail.

So, what can I do?

Thanks,

M

[anon73440385]

Your error clearly states Authentication Required and this obviously doesn’t work and your conclusion so it is not matter of mass mail comes too early, since you even cannot authenticate, which is the first hurdle to clear. So you need to fix the authentication problem first.

What are your SMTP settings (port, server)?

[Mex]

smtps.aruba.it
465
use secure connection (SSL)
and in the “server authentication…” button I added user name and password at the first option: “the outgoing mal server (SMTP) requires separte authentication”.
Is there anything wrong?
Is there any way to comunicate the bug related to the “test settings” to the LibreOffice developers?
Thanks

[anon73440385]

OK - you seem to use SMTPS using port 465, which has a quite dynamic history (assigned to be used with emails, unasssiged and assigned to another service and re-asssigned to SMTPS in 2018). Due to these changes, I’m quite unsure whether the library used in LibreOffice supports that port (and protocol). What I can say from

$ telnet smtps.aruba.it 465
Trying 62.149.156.218...
Connected to smtps.aruba.it.
Escape character is '^]'.

is, that there is a service running on that port, but it doesn’t announce itself as an MTA while:

$ telnet smtps.aruba.it 587
Trying 62.149.128.218...
Connected to smtps.aruba.it.
Escape character is '^]'.
220 smtpcmd12.ad.aruba.it bizsmtp ESMTP server ready

announces itself as an SMTP server. Thus I’d try port 587

[Mex]

Wow, it works and I’m quite surprised. Thank you very much.
I was wondering how make this clear to other people that may occur in the same problem.
Thanks again.
M

[anon73440385]

As stated above in parenthesis … (it seems to even not test the smtp port)

[anon73440385]

For the records (according to OP’s last last comment):

To check a connection (server / ports) you may use: telnet <smtpserver> <port>. If it announces itself as SMTP server, it should work. For SSL try to use port 587 (instead of port 465, which is used for SMTPS)

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.