send email using mail merge
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\mailmerge.py", line 135, in connect self.server.login(user, password) File "C:\Program Files\LibreOffice\program\python-core-3.7.7\lib\smtplib.py", line 730, in login raise last_exception File "C:\Program Files\LibreOffice\program\python-core-3.7.7\lib\smtplib.py", line 721, in login initial_response_ok=initial_response_ok) File "C:\Program Files\LibreOffice\program\python-core-3.7.7\lib\smtplib.py", line 642, in auth raise SMTPAuthenticationError(code, resp)
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.
on email setting i put user information ( name & email id ) under outgoing server server name i.e smtp.office365.com , port 587, ss tickcked mark
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 authenticationafter pressing buttonServer authentication(This is the place to provide your password for the connection).once ticket need separate authentication got this error.
<class 'smtplib.smtpsenderrefused'="">: (530, b'5.7.1 Client was not authenticated', 'xyz@ri.com'), traceback follows File "C:\Program Files\LibreOffice\program\mailmerge.py", line 288, in sendMailMessage self.server.sendmail(sendermail, truerecipients, msg.as_string()) File "C:\Program Files\LibreOffice\program\python-core-3.7.7\lib\smtplib.py", line 867, in sendmail raise SMTPSenderRefused(code, resp, from_addr)</class>
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.