Description: I created my first email using LibreOffice Writer. I opened Libre Mail Merge Wizard, and tried sending the email to a list of seven email messages (as a test) that I had set up in LibreOffice Calc, with 'Email' being in cell A1, and my list of emails in A2 to A8. Everything seemed to be going along smoothly, until I went to 'Send Documents', and then LibreOffice crashed. LibreOffice 7.3 Document Recovery Due to an error, LibreOffice crashed. All the files you were working on will now be saved. The next time .................. etc Steps to Reproduce: 1. Create an email on LibreOffice Writer, then click on Tools / Mail Merge Wizard 2. Tick ‘Use the current document’, and click ‘Next’ 3. Tick ‘Email message’, and click ‘Next’ 4. Click ‘Select Address List’ 5. Click ‘Add’, chose the LibreOffice Calc worksheet holding the list of email addresses, and click ‘OK’ 6. When presented with the ‘Insert Address Block’ mini-screen, click ‘Next’ 7. Choose ‘Hello’ as the ‘General salutation’, and click ‘Next’ 8. When ‘Adjust Layout of Address Block and Salutation’ appears, move the Salutation Position to the top of the email (surely that should be the default), and click ‘Finish’ 9. Click on the icon Send Email Messages, enter a subject, and click on ‘Send Documents’ Actual Results: LibreOffice crashed Expected Results: LibreOffice Writer mail merge wizard to have circulated my emails Reproducible: Always User Profile Reset: No Additional Info: I am using a Lenovo Ideal pad 310 running Windows 10 Not sure which hardware I am using (X86 IA32 or X86-AMD64), or which 'version'
no repro in Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: d75c5c1f61a174b3b333e9db6536ab15cc37d00b CPU threads: 4; OS: Mac OS X 12.5; UI render: Skia/Metal; VCL: osx Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded Jumbo Please write here an info from your LibreOffice's Help-About dialog (use Copy button there)
Created attachment 181755 [details] Screen shot of error messages These error messages appeared after I had clicked on 'Send Documents'
[Automated Action] NeedInfo-To-Unconfirmed
This may be a duplicate of bug 150188. To be sure, please do 2 things: 1. rename LO user profile folder, so that new folder is created, as indicated in report form with "user profile reset" 2. if still crashes, please test with LO daily master that installs separately to your working LO and doesn't take extensions. Bug is not generally reproducible and even not in LO 7.4 and master 7.5+ for those who see it with 7.3.
Dear Laurie Spragg, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Created attachment 185582 [details] Last message before crash I get here the same results. Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.1 Calc: threaded
1. Create new document -> Insert -> Field command -> More field commands 2. Add database -> Browse -> Calc-table.odt -> Table -> Mail merge fields 3. Click on field name -> Insert 4. -> Close 5. Tools -> Mail Merge Wizard 6. -> To: -> Choose address field from the database with the pulldown menu 7. -> Subject: Enter subject if necessary 8. -> Send as: Select format (here: PDF document) -> Properties 9. -> Send documents -> Crash Of particular interest is the text regarding the transfer status: "0 of 2 sent" and at the same time "Unsent emails: 0" (sic!) By the way, "Details" cannot be opened!
(In reply to Klaus from comment #6) > Created attachment 185582 [details] > Last message before crash > > I get here the same results. > Version: 7.3.7.2 / LibreOffice Community > Build ID: 30(Build:2) > CPU threads: 8; OS: Linux 5.19; UI render: default; VCL: gtk3 > Locale: de-DE (de_DE.UTF-8); UI: de-DE > Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.1 > Calc: threaded Klaus, could you please retest it in 7.5 version?
The test of mail-settings show OK On send I get the following error: <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) In Thunderbird my authentication settings are OAuth2. Could this be the problem?
There should probably be an authentification option for OAuth2 in writer smpt configuration. (by the way how can I edit my posts?)
I have now tested the serial mail dispatch with LO V 7.5. Writer no longer crashes and the mails are obviously processed, but the sending stops with an error message (see above). After reading the error message carefully, my suspicions were confirmed. Gmail no longer accepts authorisation with password only. Unfortunately, the option "less-secure access" is no longer available in Google Mail. So I can only access Thunderbird either via OAuth2 or with 2-factor authentication. I assume that this also applies with Writers mail client. So it is clear that sending serial mail with Writer will not work even in version 7.5 as long as the mail client does not handle OAuth, at least with G-Mail. I would be really grateful if someone could try this under the same conditions to verify my hypothesis, or with a mailer that does not require this authentication. Translated with www.DeepL.com/Translator (free version)
So, let's close this one as WFM because there is no crash today. Klaus, please create a new bug report about OAuth2/Gmail problem in mail merge. And thank you so much for (re)testing.