Bug 144379 - Implement OAuth2 support to use email accounts requiring such authentication in Mail Merge
Summary: Implement OAuth2 support to use email accounts requiring such authentication ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 153863 (view as bug list)
Depends on:
Blocks: Mail-Merge
  Show dependency treegraph
Reported: 2021-09-08 13:01 UTC by Stéphane Guillou (stragu)
Modified: 2023-02-27 17:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Stéphane Guillou (stragu) 2021-09-08 13:01:59 UTC
Currently, it is not possible to us an email account that requires OAuth2 authentication with the Mail Merge feature.

Steps to Reproduce:
1. Open Tools - Options - LibreOffice Writer - Mail Merge email
2. Set up an account that requires OAuth2 authentication

Actual Results:
No way to do so currently.

Expected Results:
Have extra settings to be able to use a wider variety of email account providers.

Reproducible: Always

User Profile Reset: No

Additional Info:
There exists an extension that allows obtaining a token, but mail merge is not capable of linking to it: https://github.com/prrvchr/OAuth2OOo
Comment 1 prrvchr 2021-09-09 00:41:36 UTC
Hi stragu,

I confirm that this problem exists and that I have known about it for a long time.

I tried to correct this problem and I just finished writing smtpServerOOo which will soon replace smtpMailerOOo since everything has been integrated into a single extension... 

So now if you install:
- OAuth2OOo for authorizations
- gContactOOo for a data source (your phone contacts)
- smtpServerOOo (smtpMailerOOo soon) for:
    - mailing list creation (because merging emails without a mailing list is really nonsense...)
    - merging email body in html format.
    - merging attached files also in pdf format.
- HsqlDBDriverOOo to have a functional and up to date database under the UNO API.

then you will be able to get rid of this problem quickly...
Comment 2 Stéphane Guillou (stragu) 2021-09-11 09:21:04 UTC
Thank you prrvchr! And thank you for your work on the extensions. If you agree that this should be an enhancement in LibreOffice, you can mark the bug as "NEW".

I unfortunately couldn't configure my employer's email Office365 account with the extensions, but this troubleshooting might be better done via email than here (especially to share logs that contains personal identifiers).

Hopefully something that gets integrated into LibreOffice soon! Happy to help testing things on both Linux and Windows with a variety of email accounts.
Comment 4 Timur 2022-07-29 11:37:16 UTC
"Less secure app access" that meant not to use OAuth2 in Gmail is no longer available. 
"from May 30, 2022, ​​Google no longer supports the use of third-party apps or devices which ask you to sign in to your Google Account using only your username and password".

There's something else here, that only occurred to me now. 
Why are settings for mailmerge (direct sending to mail server) and filesend (using mail program) different?
Comment 5 Stéphane Guillou (stragu) 2023-02-27 17:14:53 UTC
*** Bug 153863 has been marked as a duplicate of this bug. ***