Hi. I’ve been having a lot of problems trying to get mail merge to work and send emails. I’ve tried Libre Office 3.5 and 4.0, though I don’t think anything has changed between them with regard to mail merge.
I can’t seem to get LibreOffice to speak to my mail server. I’ve tried both my gmail and internode servers. I set the settings to be the same as my thunderbird settings, and I can send emails from thunderbird without a problem.
My internode settings match those on the web page (mail.internode.on.net, imap port 993, smtp port 465). I’ve tried a few different settings for google, as there seems to be a few around. I’ve tried smtp.gmail.com and smtp.googlemail.com, port 465, 587 and 578 as outgoing in various different combinations. I’ve also tried imap.gmail.com and imap.googlemail.com with port 993 as incoming.
There are some posts and bugs on the subject, but from what I read these problems were fixed before 3.5, and there is no fix remaining that I have found to try.
For the most part, when I either try to send mail or test settings, LO freezes for approximately half an hour, and then fails. On one occasion, I didn’t select SSL, and the test passed (very quickly). I had two green ticks. However, when I tried to send email, it failed.
Has anyone gotten mail merge to work to email recently, preferably with a gmail or internode account? Is there something else I maybe should be thinking of? The job is starting to get rather urgent. I’d include the error, but I have to wait half an hour, as I just kicked it off again. I’ll edit this post later.
Here is the error I get (after about half an hour) when I have all of my settings in place.
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 'imaplib.IMAP4.abort'>: socket error: EOF, traceback follows C:\Program Files\LibreOffice 4.0\program\python-core-3.3.0\lib\imaplib.py:1068 in function _get_line() [raise self.abort('socket error: EOF')] C:\Program Files\LibreOffice 4.0\program\python-core-3.3.0\lib\imaplib.py:969 in function _get_response() [resp = self._get_line()] C:\Program Files\LibreOffice 4.0\program\python-core-3.3.0\lib\imaplib.py:202 in function _connect() [self.welcome = self._get_response()] C:\Program Files\LibreOffice 4.0\program\python-core-3.3.0\lib\imaplib.py:173 in function __init__() [self._connect()] C:\Program Files\LibreOffice 4.0\program\mailmerge.py:305 in function connect() [self.server = imaplib.IMAP4(server, port)]
Thanks in advance!