Confirming also on LO 4.0.2.2, 3.6.5 on OSX 10.8.3

This used to work in 3.3.x (although I haven't tested recently).

It also might be a DUP of a previously entered report (will have to look).


Alex

Dan,


For gmail, these are the settings that worked for me :

SSL option ticked
smtp.googlemail.com
Port 25

Under "Server Authentication"
Tick "Outgoing mail server (SMTP) requires authentication"
Select "The outgoing mail server requires separate authentication"
User name : enter full Gmail address here, including the @gmail.com
Password : fill in with password

No need to configure the Incoming Mail Server options


Alex

I couldn't figure out the way to have mailmerge working with my Gmail SMTP but when I did the debug of the mailmerge.py script I've discovered that a SSL connection isn't handled properly.
At the line where the server object is created I found:

self.server = smtplib.SMTP(server, port,timeout=tout)

but in case of SSL connection the correct statement should be:

self.server = smtplib.SMTP_SSL(server, port,timeout=tout)

So, I did this simple change and my Gmail SMTP (smtp.gmail.com) works perfectly on port 465.
I didn't even checked the "Use SSL" checkbox in the mailmerge configuration windows.

I think a good patch should make a choice between smtplib.SMTP and smtplib.SMTP_SSL according to the "Use SSL" checkbox.

Cheers.

   Andrea

Hello, I confirm THIS IS A BUG AND NEED URGENT SOLUTION please
LibreOffice Writer crash miserably when I try to send documents via email
I have my settings perfectly configured, port, ssl, smtp server, etc. and this freeze completely.
I did the changes that Andrea suggested but in my case are not working...

*** Bug 75481 has been marked as a duplicate of this bug. ***

*** Bug 64098 has been marked as a duplicate of this bug. ***

Thank you Andrea/FS for your ideas (see https://bugs.documentfoundation.org/show_bug.cgi?id=64098#c15 + https://bugs.documentfoundation.org/show_bug.cgi?id=63388#c6),
I'll submit a patch with these.

*** Bug 58703 has been marked as a duplicate of this bug. ***

It seems the patch is wrong (see https://gerrit.libreoffice.org/#/c/14572/), so abandonned it.
Certainly someone will know how to fix this.

This bug is also reported at ask.libreoffice.org: 

http://ask.libreoffice.org/en/question/13337/why-wont-mail-merge-connect-to-my-outgoing-email-server/

*** Bug 99363 has been marked as a duplicate of this bug. ***

Jan-Marek: a solution has been proposed by prrvchr in tdf#99363.

Work fine for me, but need some Google Mail Account setting requirement:

Load: https://myaccount.google.com/security?utm_source=OGB#connectedapps

You must enable less secured application. Needed but apparently the connection is under SSL...

I make an extension gMailOOo:

https://github.com/prrvchr/gMailOOo?files=1

Who implements ssl and tls as well as OAuth2.
Uno api uno seems obsolete and requires an upgrade.

Interface who need modification:

com.sun.star.mail.XMailService

getSupportedConnectionTypes: return (Unsecure, Ssl, Tls)

getConnectionType: after connection return Ssl (effective connection type)

getSupportedAuthenticationTypes: return (None, Login, Component)

getAuthenticationType: after connection return effective authentication type

Connect(xConnectionContext, xAuthenticator)

xConnectionContext:

ServerName
Port
ConnectionType
AuthenticationType
Timeout

xAuthenticator

getUserName
getPassword
getComponent

PopbeforeSmtp and ImapbeforeSmtp are old technology that was used when smtp did not handle authentication.
It may no longer be necessary to keep it.

This bug still exists in latest LibreOffice at time of writing (5.3.2)

Platform: Windows x64
Version: 5.3.2

SMTP: smtp.office365.com
Port: 25
SSL: Both TLS/SSL and StartTLS cause the crash when testing.

Steps to reproduce: 

Do as original poster (Dan Lewis) did.  Nothing has changed here.

---

This bug is now 5 years old and affects Office 365 SMTP as well as Google Apps.  These are two of the biggest business e-mail providers in terms of client base.  Small business can't use LibreOffice until this is fixed.

I appreciate LibreOffice devs have a lack of resources, but this is basic functionality that prevents me and many of the clients I support from dumping Microsoft Office and by extension, Windows.

at Martyn Hare:

can you try to install this extention:

https://github.com/prrvchr/gMailOOo/raw/master/gMailOOo.oxt

It work now on Windows...

hello,
there is a problem when you use SMTP with the port 465 
you must use a smtplib.SMTP_SSL with this port.
Proposed code in mailmerge.py : 
		if port == 465:
			self.server = smtplib.SMTP_SSL(server, port,timeout=tout)
		else:
			self.server = smtplib.SMTP(server, port,timeout=tout)

		if dbg and os.name != 'nt':
			self.server.set_debuglevel(1)

		connectiontype = xConnectionContext.getValueByName("ConnectionType")
		if dbg:
			print("ConnectionType: " + connectiontype, file=dbgout)
		if connectiontype.upper() == 'SSL' and port != 465:
			self.server.ehlo()
			self.server.starttls()
			self.server.ehlo()

Jurassik: if you want to contribute and submit your patch, you can give a look to https://wiki.documentfoundation.org/Development/GetInvolved

For the moment, there's no patch pushed on sources so this bug is not fixed.

(In reply to prrvchr from comment #24)
> A three-state control is required for the choice of connection security
> (none, Ssl, Tls)
> 
> Same for authentication (without, login, oauth2)
> 
> Take look at:
> https://forum.openoffice.org/en/forum/viewtopic.php?f=47&t=89140

with my mailmerge.py code : 
for use of SMTP port 25 : 
don't check ssl checkbox
for use of SMTP port 465 :
check ssl checkbox
for use of SMTP port 587 :
check ssl checkbox

Julien Nabet english is not my natural language but if i have understand your link, you must build or download all the source of libreoffice to make a patch. Sorry but it is too complicated for me to do a patch. Only a few lines change in mailmerge.py

hello,
if you want to try my file mailmerge.py you can find here : 
https://www.developpez.net/forums/attachments/p291448d1499211299/logiciels/logiciels-libres-open-source/bureautique/openoffice-libreoffice/envoyer-email-courriel-contacts/mailmerge.py/

tried with LibreOffice 5.2.7.2

*** Bug 109019 has been marked as a duplicate of this bug. ***

Created attachment 134677 [details]
mailmerge.py patch to work with smtp port 465

would work since version 5.0 of libreOffice

(In reply to Jurassic Pork from comment #21)
> hello,
> there is a problem when you use SMTP with the port 465 
> you must use a smtplib.SMTP_SSL with this port.
> Proposed code in mailmerge.py : 
> 		if port == 465:
> 			self.server = smtplib.SMTP_SSL(server, port,timeout=tout)
> 		else:
> 			self.server = smtplib.SMTP(server, port,timeout=tout)
> 
> 		if dbg and os.name != 'nt':
> 			self.server.set_debuglevel(1)
> 
> 		connectiontype = xConnectionContext.getValueByName("ConnectionType")
> 		if dbg:
> 			print("ConnectionType: " + connectiontype, file=dbgout)
> 		if connectiontype.upper() == 'SSL' and port != 465:
> 			self.server.ehlo()
> 			self.server.starttls()
> 			self.server.ehlo()

I made your changes to today's version of LO on Win7 x86 (still v5.3.4), but I just get

<class 'AttributeError'>: 'module' object has no attribute 'SMTP_SSL', traceback follows
  File "C:\Program Files\LibreOffice 5\program\mailmerge.py", line 110, in connect
    self.server = smtplib.SMTP_SSL(server, port,timeout=tout)

when I try to use SSL to port 465.

It appears that there is no guarantee that the Python included with LO has SSL support enabled.

This is reinforced by the following error if I try port 587 with SSL

<class 'RuntimeError'>: No SSL support included in this Python, traceback follows
  File "C:\Program Files\LibreOffice 5\program\mailmerge.py", line 128, in connect
    self.server.starttls()
  File "C:\Program Files\LibreOffice 5\program\python-core-3.3.0\lib\smtplib.py", line 663, in starttls
    raise RuntimeError("No SSL support included in this Python")


So, any clues as to how I get a version of LO with SSL actually working ? Is it a lottery ? It obviously worked for your version - what platform were you using it on ?

(In reply to Tangine Melroux from comment #33)
> FIX:
> 
> LO Version: 5.3.4.2
> Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3
> Win 7 x86
> 
> C:\Program Files\LibreOffice 5\program\python-core-3.3.0\lib\_ssl.pyd
> 
> is useless
> 
> download Python 3.3.5 MSI from python.org and install
> 
> copy
> 
> C:\Program Files\Python33\DLLs\_ssl.pyd
> 
> from there to overwrite broken LO.
> 
> Now two blue ticks for tests at ports 465 and 587 with Jurassik's patch
> 
> 2013 ???

EDIT: NOT A FIX

LO 'Send E-mail Messages' button in new toolbar gets to the last step, dialog box flashes up momentarily (too fast to read) - no errors indicated, but no e-mail messages actually sent.

Trying to find where LO stores error logs on Windows reveals that it doesn't - so no further progress possible - all Googling shows either Mac/Linux solutions to log location or nightmare nonsense like

---
"C:\OpenOffice\program\soffice.exe" -Xdebug -env:RTL_LOGFILE=c:\\OpenOffice -Xrunjdwp:transport=dt_socket,server=y,address=22222 -invisible -"accept=socket,host=0,port=22222;urp;debug=true"
works partial.

It creates a file
c:\OpenOffice2_10600.log
But it remains empty.

---

LO 5.3.5.2
Build ID: 50d9bf2b0a79cdb85a3814b592608037a682059d
OS: Win7 v6.1 Build 7601 SP1

server: smtp.fastmail.com SMTP port: 465

Still not working:

LibreOffice could not connect to the outgoing mail server. Check your system's settings and the settings in LibreOffice. Check the server name, the port and the secure connections settings
--
<class 'smtplib.SMTPServerDisconnected'>: Connection unexpectedly closed, traceback follows
  File "C:\Program Files (x86)\LibreOffice 5\program\mailmerge.py", line 107, in connect
    self.server = smtplib.SMTP(server, port,timeout=tout)
  File "C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\lib\smtplib.py", line 241, in __init__
    (code, msg) = self.connect(host, port)
  File "C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\lib\smtplib.py", line 322, in connect
    (code, msg) = self.getreply()
  File "C:\Program Files (x86)\LibreOffice 5\program\python-core-3.3.0\lib\smtplib.py", line 375, in getreply
    raise SMTPServerDisconnected("Connection unexpectedly closed")

Hi.

I had a similar problem with LO 5.4.0.3 on Linux Mint 17.3 and LO 5.2 under Windows 7 (although after about ~ 10 mn, the window would unfreeze and I would get a proper error message for the connexion testing).

It was solved once I changed the port from 465 to 587. 
The problem was that 'SSL connexion' may means SSL/TLS (which was port 465 with my SMTP server) or STARTTLS (which was port 587 with the SMTP server).

Emailing and Libo 5.4.4.2 hang when clicking on button "Sélectionner une liste d'adresses".

It would be better to remove this function from menu.

Linux Mint 18.3

Justin Luth committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=036b51dbc49b533d1db773d8627d56ab86bca487

tdf#63388: use SMTP_SSL for port 465

It will be available in 6.1.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

Thanks to Jurassic Pork (comment 21) and prrychr (tdf#99363) for the 2016 patch. 

A few related changes have resulted in this situation for LO 6.1
-secure SMTP is now default with port 587 (StartTLS).
-POP3/IMAP also default to secure ports.
-Port 465 uses smtp_ssl (regardless of the setting labeled SSL, but which actually implements StartTLS in the case of SMTP). SO, PORT 465 IS THE ONLY PORT THAT LIBREOFFICE CAN USE FOR SSL SMTP.

So, I think this will take care of most of the concerns mentioned in this report. I'm not going to mark this one as resolved since there are so many different angles in this bug.

Todo:
1) The term "SSL" is correct for POP3/IMAP settings in the authentication portion (right?), but for SMTP, "SSL" is different (and incompatible) with "StartTLS". Consider the three-way logic of comment 18.

2) test smtp_ssl works on the shipping version of python (comment 32, 33, 34). It works for me in Ubuntu 16.04 / 18.04.

3) LibreOffice freezes when clicking Test Settings button. That is the title of this bug, although there was very little in the discussion about this specific aspect.

If, after testing 6.1, there are still concerns about any of these topics, I recommend opening a new bug about that one particular topic, and linking it back to this report.

*** Bug 48538 has been marked as a duplicate of this bug. ***

Hi all,

I come back and I are ready now to modify Uno Api (mailmerge.py) to be compatible with new SMTP servers technologie:
- The chosen port does not determine the security but only port... 
- For security available choices are: None, TLS or SSL
- For Authentication available choices: None, Login, OAuth2
I know now how to create idl file, and compile them to rdb file...

I could try to do it now, but with some help to define the new method of idl and want that this correction is produced as an extension compatible with OpenOffice ...

I'm waiting for a reply, thank you.

Hi,
If you want to get closer to the quality of an email client's configuration like Thunderbird, we need:
- use Mozilla ISPDB
- create a Configuration Wizard based on ISPDB.
- integrate in SMTP services an InteractionHandler calling the Configuration Wizard if a parameter is missing

Does anyone in this report experience any problem with a fresh master build? There were recent fixes to mail merge code.

There hasn't been a duplicate or "me too" comment since Justin's 2018 commit, and no reply to Buovjaga's question from a year ago, so closing as fixed by Justin's commit.

If issues remain, please see if it has already been reported: https://bugs.documentfoundation.org/showdependencytree.cgi?id=102998&hide_resolved=1
If not, please open a new report.

prrvchr, if you want to improve mail merge with larger-scale changes, I think it would be good to write to the dev mailing list to reach more people and get other opinions: https://lists.freedesktop.org/mailman/listinfo/libreoffice
Much appreciated!