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)

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.

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 authentication after pressing button Server 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)

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.

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