Apache OpenOffice (AOO) Bugzilla – Issue 93583
Mailmerge fails to communicate with SMTP server (Not SSL)
Last modified: 2010-01-08 19:05:52 UTC
When testing the account settings for mailmerge, the system fails to connect to the SMTP server. (I'm using the same settings as I use for Mac Mail.) Ignoring this problem and actually trying to send the mailmerge fails to send anything too. To reproduce the problem: 1 Create a spread sheet with a column that contains emails. 2 Create a document using Writer. 3 In Writer, click Tools->mail merge wizzard, and go through the wizard until it asks you for mail account settings. I used my Yahoo (plus) account which allows pop and smtp. I don't check SSL, I do check authentication for SMTP. 4 After I click test, it fails to connect to the SMTP server even though I'm convinced my settings are correct and I've tried four different times. (I tried using SSL settings too.)
Reassigned to HI.
I have the same problem. My localhost test smtp server doesn't work either.
Also having this issue. Tested several server configurations both with GMail and private SMTP server. Running: Leopard 10.5.5 Open Office 3.0.0 Thanks much!
Works in SO. I think this one depends on issue 90701 isn't it.
I doubt it.
I'm having this problem too. I can't even test my settings in the preferences "E-mail mail merge" pane. Can anyone else successfully test their server settings? http://www.openoffice.org/issues/show_bug.cgi?id=99078
*** Issue 99078 has been marked as a duplicate of this issue. ***
I am also having this issue in OpenOffice 3.1 on Windows XP Pro. My mail account settings are all fine and tested in Thunderbird (I use both Gmail and Hotmail via pop3). I can't get past the "test settings" in the Mail Merge Email dialogue box. Open Office freezes when I test my account settings - which work fine in Thunderbird.
*** Issue 104964 has been marked as a duplicate of this issue. ***
I'm expermenting/testing with OOo 3.1.1 to see if this product is a good move from Microsoft Office for our organization. We are running Windows XP SP2, using Thunderbird 2.0.0.23, with OOo 3.1.1 and I'm getting this exact error as well. If I'm trying to do a mail merge to email, I don't get any errors but it never sends any of the emails and seems like its in a loop (trying to find the server and can't). If I go through the options to setup and test the settings then I'll get the exact same errors as everyone else here. In Issue 95849 it says to make sure Python-Uno is installed but I've checked the install and its a component installed by default. By reading all the issues submitted in regards to this, it seems as though this has always kind of been an issue in almost every new version after 2.4.0 (something like that). If anyone has a resolution/suggestions it would greatly be appreciated.
It probably just requires someone with a modicum of python to have a look at this under Windows and/or MacOSX and fiddle with mailmerge.py. But I have neither of those operating systems.
How about just warning folks that the feature doesn't work on Mac OS X? This thing has been chewing up people's time for well over a year, now. I spent an hour mucking with it before deciding it was probably a bug and another 20 minutes confirming that hypothesis. I would rather have put that time into working on the problem... Between the lot of us, we would have solved the thing by now. Geesh.
So, I tested this on windows (always worked under Linux) and with tools->options->openoffice.org writer->email settings a) an smtp server at port 25 b) ssl unchecked server authentication c) The outgoing mail server requires authorization checked d) The outgoing mail server requires separate authentication checked username password This works fine for me from windows xp, mails definitely get sent.
A second test in windows with a gmail account: tools->options->openoffice.org writer->email settings a) an smtp server of smtp.gmail.com at port 587 b) ssl checked server authentication c) The outgoing mail server requires authorization checked d) The outgoing mail server requires separate authentication checked username password bzzt. "No SSL support included in this python" So thats the answer to one problem anyway. The windows ssl support isn't compiled into python.
So this bug has accumulated a lot of different "duplicates" and I don't think they are all actually duplicates at all. So for anyone who has trouble under Window *and* with "Use secure connection" see issue 106542 for a possible workaround and the future fix for this. The original report is for MacOSX and *not* using "Use secure connection"
If anyone is using CRAM-MD5 authentication, then that problem is fixed with issue 105669. Issue 105669 has a replacement mailmerge.py attached to it which you could try overwriting your original with to see if that makes a difference.
I've fixed a pair of *possibly* related issues, I'd be interested if the experimental Mac Intel install set which includes those fixes at ftp://qa-upload.services.openoffice.org/pythonssldedux/aqua/ makes any difference to the original macosx issues reported here
Problem seems to be the same on Linux since OOo 3.0 (also tested with 3.1.1): Reproduction: 1) Configure Tools->Options-Writer->E-Mail merge (do not know exact english labels) with SMTP server 2) Enter authentication details (SMTP AUTH) 3) Test will result in "network ok", but "search for SMTP server" failed It is no matter, if I use an external relay server or my own LAN one. But - and this is strange - if I switch off "server needs authentication" then: 3) Test will result in "network ok", but "search for SMTP server" succeeds! So this actually seems to be a general authentication issue in smtplib.py? This is the output I get, when I try to send merged e-mails with authentication switched on: ~~~~~~~~~~~~~ snip ~~~~~~~~~~ <class 'smtplib.SMTPSenderRefused'>: (501, '5.5.4 BASE64 decoding error', u'me@example.org'), traceback follows /opt/openoffice.org/basis3.1/program/python-core-2.6.1/lib/smtplib.py:698 in function sendmail() [raise SMTPSenderRefused(code, resp, from_addr)] /opt/openoffice.org/basis3.1/program/mailmerge.py:193 in function sendMailMessage() [self.server.sendmail(sendermail, truerecipients, msg.as_string())] ~~~~~~~~~~~~~ snip ~~~~~~~~~~ Hope this helps ...
cmc->martinschniewind: There's a lot of mission creep with this bug, so this particular one is only for MacOSX and hopefully someone there can test the packages at ftp://qa-upload.services.openoffice.org/pythonssldedux/aqua/ to see if they make a difference. For your problem you can see if ftp://qa-upload.services.openoffice.org/pythonssldedux/linux makes a difference, and if it does not then open a new bug and assign it to me (cmc) and give all the exact details of the settings you are using
No feedback on the mac install sets. But I feel fairly confident that this is a duplicate of some of the specific bugs/missing python pre-requisites I was able to find in the vanilla windows and linux built-in python. I'll leave the testing install sets up for a few weeks if anyone wants to give them a go, otherwise tests can be done on any development snapshots from DEV300_m69 onwards up to the 3.3 release
closing, m69 onwards
@cmc: I tried your install set when you had uploaded it, but I couldn't tell much difference compared to the official 3.1 release, i.e. they both worked to some degree (with the combination of options I tried). Can that be because I may have newer versions of python installed?