Bug 153863

Summary: Writer Mail Merge needs OAuth authentification to work with G-Mail
Product: LibreOffice Reporter: Klaus <klbogotz>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: stephane.guillou
Priority: medium    
Version: 7.5.0.3 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description Klaus 2023-02-27 17:09:28 UTC
Description:
I have tried sending a serial mail with Writer and found that the sending does not work. My mail server is G-Mail. The mail server only accepts authorisation with OAuth2 or 2-factor authorisation. Serial sending is not possible with 2-factor authorisation, so only OAuth remains as a method to use Writer Mailmerge with G-Mail. This should be implemented in Writer.


Steps to Reproduce:
1. Start with the standard Mailmerge procedure
2. Send mails

Actual Results:
The mails are processed but not send.
Error message:
<class 'smtplib.SMTPSenderRefused'>: (530, b'5.7.0 Authentication Required. Learn more at\n5.7.0  https://support.google.com/mail/?p=WantAuthError fm16-20020a05600c0c1000b003dd1bd0b915sm6639753wmb.22 - gsmtp', 'Klaus.Bogotz@gr7.org'), traceback follows
  File "/usr/lib/libreoffice/program/mailmerge.py", line 262, in sendMailMessage
    self.server.sendmail(sendermail, truerecipients, msg.as_string())
  File "/usr/lib/python3.10/smtplib.py", line 887, in sendmail
    raise SMTPSenderRefused(code, resp, from_addr)


Expected Results:
Messages should have been prozessed and sent.


Reproducible: Always


User Profile Reset: No

Additional Info:
OAuth should be implemented as another option to work with G-Mail
Comment 1 Stéphane Guillou (stragu) 2023-02-27 17:14:53 UTC
Thank you Klaus. This has been reported before in bug 144379

*** This bug has been marked as a duplicate of bug 144379 ***