[Solved] Could not connect to the outgoing mail server

Discuss the word processor

[Solved] Could not connect to the outgoing mail server

Postby joejac » Mon Nov 26, 2012 5:19 pm

Hello,

Last year I was able to manage a Writer template to send my yearly email to my customers, it worked fine. The email has variables connected to their corresponding data in a Worksheet registered in the OpenOffice Database. Everything worked fine with OO 3.3 but yesterday I was trying with same parameters and same Gmail Account and it did not work.

1. In OpenOffice.org Writer Tools - Options - OpenOffice.org Writer - Mail Merge E-mail.
I get this error:
"OpenOffice.org could not connect to the outgoing mail server. Check your system's settings and the settings in OpenOffice.org. Check the server name, the port and the secure connections settings".
I used smtp.gmail.com as the outgoing server port 587 (also port 465)
SSL - SMTP Server requires authentication is checked, with the gmail email and correct password, like it was last year.
These are the proposed Gmail values, and Gmail account has POP and IMAP enabled, I have Win 7.

2. Then I downloaded and Installed OO 3.4.1 and updated Java to the latest version, and same problem, I checked the firewall and Java, OO.org OO Writer and OO Base are allowed.

3. Then I moved the files to a Linux PC and test them with Libre Office 3.5.5.3 and even worst, no connection with internet, but Firefox is connecting fine.

I do not understand, if everything was working fine in November 2011 and I have the emergency of sending the email no later than tomorrow :(

Hope someone can help.
Best regards
joejac
Last edited by Hagar Delest on Sun Dec 02, 2012 12:02 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 3.4.1 on Windows 7
joejac
 
Posts: 2
Joined: Mon Nov 26, 2012 5:01 pm

Re: Mail Merge E-mail-OO not connect to the outgoing mail se

Postby loucherry » Sun Dec 02, 2012 12:02 am

Hi,
I use "smtp.googlemail.com" as the outgoing server. Could that be your error?
Lou

I've been trying to use merge E-mail myself, but this is as far as I get. I haven't been able to find the procedures to follow to insert fields in both the address and in the message proper. Any chance you could point me in the right direction?
Lou louwcherry @ gmail . com
Open Office 3.3 on Windows 7
loucherry
 
Posts: 2
Joined: Sat Oct 27, 2012 3:37 am

Re: Mail Merge E-mail-OO not connect to the outgoing mail se

Postby joejac » Sun Dec 02, 2012 1:14 am

Thanks loucherry,

Unfortunately with "smtp.googlemail.com" did not work either, and this do not comply with gmail instructions, please see this:
http://support.google.com/mail/bin/stat ... 75726&rd=1

With regard to your question here are the links that helped me:
http://blog.worldlabel.com/mail-merge-i ... ed-to-know
http://davidmburke.com/2011/08/10/mail- ... breoffice/
http://wiki.openoffice.org/wiki/Documen ... rge_Wizard

Sorry for my delay, but I had to find other alternatives, I solved the problem with Gmail and Google Docs with a public script, in case you or somebody need this, I provide the links.

1.- Firefox Extension: Mailmerge, it looks very good, but I do not like to use the browser for tasks different than browsing
https://addons.mozilla.org/en-us/thunde ... ail-merge/

2.- How to Mail Merge in Gmail, this is the one I used, I do not like because it forced me to depend on a web service and I prefer solutions in my desktop not on the web, but it is easy and fast for a temporary solution:
http://www.youtube.com/watch?feature=pl ... eEIbbABBSo

3.- Other Links:

http://googleappsdeveloper.blogspot.com ... oogle.html
http://skvnet.blogspot.com/2011/11/pers ... gmail.html

Hope this can help
Best regards

joejac
OpenOffice 3.4.1 on Windows 7
joejac
 
Posts: 2
Joined: Mon Nov 26, 2012 5:01 pm

Re: [Solved] Could not connect to the outgoing mail server

Postby Hagar Delest » Thu Jul 25, 2013 11:24 pm

For the record: The Spirit of Discordance. Presenting "TVHGoogleMAPI", an Apache-license open source project that makes GMail a registered "Simple MAPI" protocol handler on Windows.
AOO 4.1.6 on Xubuntu 18.10 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28387
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Writer

Who is online

Users browsing this forum: No registered users and 23 guests