Ask Your Question

send email using mail merge

asked 2020-08-11 16:02:48 +0100

satya1 gravatar image

while sending email using mail merge its getting erro.

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.smtpauthenticationerror'="">: (535, b'5.7.3 Authentication unsuccessful [BMXPR01CA0002.INDPRD01.PROD.OUTLOOK.COM]'), traceback follows File "C:\Program Files\LibreOffice\program\", line 135, in connect self.server.login(user, password) File "C:\Program Files\LibreOffice\program\python-core-3.7.7\lib\", line 730, in login raise last_exception File "C:\Program Files\LibreOffice\program\python-core-3.7.7\lib\", line 721, in login initial_response_ok=initial_response_ok) File "C:\Program Files\LibreOffice\program\python-core-3.7.7\lib\", line 642, in auth raise SMTPAuthenticationError(code, resp)

edit retag flag offensive close merge delete


535, b'5.7.3 Authentication unsuccessful

But you did not provide SMTP Data especially which port settings and security level (SSL) you are using and some providers only allow SMTP connections from certain (own) email addresses. So there is no more to say than "Your provider denies to use their SMTP gateway" and in fact the problem is either with your settings or with your provider.

Opaque gravatar imageOpaque ( 2020-08-11 16:19:42 +0100 )edit

on email setting i put user information ( name & email id ) under outgoing server server name i.e , port 587, ss tickcked mark

satya1 gravatar imagesatya1 ( 2020-08-11 16:25:46 +0100 )edit

You need make settings under Tools -> Options -> LibreOffice Writer -> Mail Merge Email. You did not mention that you ticked option [X] The outgoing mail server (SMTP) requires separate authentication after pressing button Server authentication (This is the place to provide your password for the connection).

Opaque gravatar imageOpaque ( 2020-08-11 16:36:31 +0100 )edit

once ticket need separate authentication got this error.

<class 'smtplib.smtpsenderrefused'="">: (530, b'5.7.1 Client was not authenticated', ''), traceback follows File "C:\Program Files\LibreOffice\program\", line 288, in sendMailMessage self.server.sendmail(sendermail, truerecipients, msg.as_string()) File "C:\Program Files\LibreOffice\program\python-core-3.7.7\lib\", line 867, in sendmail raise SMTPSenderRefused(code, resp, from_addr)</class>

satya1 gravatar imagesatya1 ( 2020-08-12 08:57:58 +0100 )edit

530, b'5.7.1 Client was not authenticated

It seems that your provider only allows certain apps to use their SMTP server. Turn to your provider, since it doesn't seem to be a problem of LibreOffice but your SMTP provider.

Opaque gravatar imageOpaque ( 2020-08-12 11:48:10 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-08-11 16:28:02 +0100

Pansmanser gravatar image

The LO e-mail seems to be dysfunctional. If you use the wizard, it tries to access you default e-mail client and fails. However, if you use the use the 'send-email' button, the 4th in this illustration, LO uses it's own mail handler and it works.

image description

It brings up this dialog:

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-08-11 16:02:48 +0100

Seen: 160 times

Last updated: Aug 11 '20