With LO v5.2.5 I can no longer send emails with mailmerge. Last time I used it successfully was one year ago with LO v5.0.4. This is although I still can connect to the server with the following settings (no error message): smtp.gmail.com Port 587 SSL option ticked 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 The following settings don't work neither and return an error not reaching the smtp server: Port 465 SSL option unticked or ticked As there is a connection to the smtp server it seems like the mails are not passed on to gmail. I only found few bugs similar to this: connection yes but no sending mails nonetheless. I don't have no clue after a few hours of searching the web how to get around this. Can anyone help me on this?
Dear Reporter, Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
I tested on a different notebook with LO 5.3.0 (32bit). It's exactly the same behaviour. BTW, the writer document and the input table (LO Base) with the email addresses are the same like a year ago when it worked. It's just the values which have changed. This is to prove that the cause cannot be there.
Are you entering the mail server information during the mail merge process? Or in the Writer Options settings? There is another user reporting a similar issue in the Ask LibreOffice forum. https://ask.libreoffice.org/en/question/66768/why-does-lo-writer-tell-me-that-the-test-account-settings-is-successful-connection-to-outgoing-mail-server-was-established-2-of-2-emails-sent-but-then/ Entering the mail server info into the Writer Options worked for him. Options > LibreOffice Writer > Mail Merge E-mail If that works for you, then it appears there is a bug in the Writer mail merge dialogs not properly saving the mail server info.
In fact, below the line I experience the same. But the difference is that I enter the mail server information in the Writer option settings and it does not work for me. I'm not aware of being able to define the server parameters inside the mail merge process. Where along the process do I find that? Or does "inside" simply mean before starting the mail merge process? Then it's no difference because I tryed that also.
The last sentence should read: Or does "inside" simply mean after starting the mail merge process? Then it's no difference because I tryed that also before.
*** This bug has been marked as a duplicate of bug 48538 ***
My bug may be a duplicate to whatever but definitely not to bug 48538. This bug claims not to be able to connect to the outgoing mail server. This is not my issue, my connection is working (no error message on testing the connection). My issue is, despite of having the connection mail merge is passing the mails on to the mail server. Since it was working with LO 5.0.4 but no longer with the current version, something must have changed in between.
My bug may be a duplicate to whatever but definitely not to bug 48538. This bug claims not to be able to connect to the outgoing mail server. This is not my issue, my connection is working (no error message on testing the connection). My issue is, despite of having the connection mail merge is not passing the mails on to the mail server. Since it was working with LO 5.0.4 but no longer with the current version, something must have changed in between.
I checked out which older versions still work. So 5.04 and 5.1.6 still work with the same settings as described. 5.2.5 and 5.3.1 do not work. Any ideas what has led to that behaviour?
I made it working in 5.2.5 64bit with an odd workaround. Going through the mail merge dialog, in step 3 I have to click "Choose address list" I find my registered base file and the relevant table is already selected. Despite of that I have click "Other table" and choose preview of the selected address list, then select twice OK, then still in step 3 choose Complete. Then I can prepare mail and send it. That's the only way I got it working. No one will believe it, but I was going through that procedure and varyied everytime one piece of it and eventually only that combination worked. Not with having it resolved but having a workaround I will close the bug.
(In reply to Reto from comment #10) > I made it working in 5.2.5 64bit with an odd workaround. Going through the > mail merge dialog, in step 3 I have to click "Choose address list" I find my > registered base file and the relevant table is already selected. Despite of > that I have click "Other table" and choose preview of the selected address > list, then select twice OK, then still in step 3 choose Complete. Then I can > prepare mail and send it. That's the only way I got it working. No one will > believe it, but I was going through that procedure and varyied everytime one > piece of it and eventually only that combination worked. Jan-Marek: what do you think of the above?
Additional info: It's the preview which makes it work. After the preview it doesn't matter what I do next (click ok/cancel/complete), it's even ok to only preview another than the relevant table, it just works. It works as long as LO incl. quickstarter is not closed. After a restart it just needs a previev again.
I'm surprised to see no one responding to this bug. Is it possibly due to the status "Resolved - Worksforme" which might lead to think this is well enough? Of course it's true that it works, but it's not how it should. And since mail merge is a standard functionality quite often used, it should be worth it to get fixed. Can at least someone confirm that I'm not the only one facing this misbehavouir? That might give it more weight.
Sure, let's set back to unconfirmed as WFM are ignored.
Confirming with Version: 5.3.2.2 Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1 Threads CPU : 8; Version de l'OS :Mac OS X 10.12.4; UI Render : par défaut; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR.UTF-8); Calc: group The message on screen after connection to the Google smtp server appears to indicate that the mailmerge email was successfully sent, but in fact it isn't.
When testing hte connection in a debug master build, I see this : <class 'socket.gaierror'>: (8, 'nodename nor servname provided, or not known'), traceback follows File "/Applications/LibreOfficeDev.app/Contents/Resources/mailmerge.py", line 106, in connect self.server = smtplib.SMTP(server, port,timeout=tout) File "/Applications/LibreOfficeDev.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.5/smtplib.py", line 251, in __init__ (code, msg) = self.connect(host, port) File "/Applications/LibreOfficeDev.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.5/smtplib.py", line 335, in connect self.sock = self._get_socket(host, port, self.timeout) File "/Applications/LibreOfficeDev.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.5/smtplib.py", line 306, in _get_socket self.source_address) File "/Applications/LibreOfficeDev.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.5/socket.py", line 689, in create_connection for res in getaddrinfo(host, port, 0, SOCK_STREAM): File "/Applications/LibreOfficeDev.app/Contents/Frameworks/LibreOfficePython.framework/Versions/Current/lib/python3.5/socket.py", line 728, in getaddrinfo for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
Sorry, my bad, ignore previous comment and python error, I put the wrong FQDN in for the gmail service. Entering the correct value as indicated in the OP, I get no error messages on testing the connection. Am enclosing lldb output.
Created attachment 132883 [details] lldb output
For the record, I chose to send as HTML with the trace provided. It appears that there is a problem with constructing/converting the document from the on-screen display, or else in constructing the email itself, as these looks suspicious: Throwing InvalidHeaderException Throwing InvalidHeaderException Throwing InvalidHeaderException Throwing InvalidHeaderException Throwing InvalidHeaderException which seem to be thrown as a result of incomplete font integration. Then we see the following : warn:sfx.doc:1185:1:sfx2/source/doc/docfile.cxx:703: Physical name not convertible! warn:legacy.osl:1185:1:sw/source/ui/dbui/mmresultdialogs.cxx:1148: row of current document could not be selected warn:dbaccess:1185:1:dbaccess/source/core/api/RowSetBase.cxx:207: ORowSetBase::getValue: Illegal call here (we're before first or after last)! warn:sw.core:1185:1:sw/source/core/attr/calbck.cxx:170: a 8SwDepend client added as listener to a 12SwCharFormat during client iteration. warn:vcl:1185:1:vcl/source/window/window.cxx:529: Window::~Window: inconsistency in top window chain! which would appear to indicate that there is also a problem with the listener added to SwCharFormat
Meanwhile I'm on LO 5.4.3 and the behaviour is still unchanged. Unless I preview the table with the address list from within LO it doesn't work. After previewing it works as long as the quick starter is up. With closing the quick starter LO "forgets" the preview and I have to preview anew.
The bug is fixed with LO v6.0.2
Thanks for the feedback, let's use status WORKSFORME, since the fixing change is unknown.
I presume that it's been fixed together with bug 103919.