Description: I have a Template, I have a spreadsheet (ods) when I fire off the email merge and tell it to do from 2 to 9, (because I've heard it decrements the first number, so 1 goes to 0), it says it's creating 2 to 8 and then sits there til it times out. I tried 7.4.6.2 and I tried the most recent 6.4 and it hung for both. The spreadsheet has 9 lines of information for 9 people. Steps to Reproduce: 1.Bring up the template in writer 2.Point it to the correct spreadsheet database 3.click on send email messages 4.follow process and it should hang. I can help be sending the actual template, the database spreadsheet is sort of proprietary but I can send a fake version. Actual Results: Mail Merge Hangs after it says it created the emails (before it sends them) Expected Results: 9 people should have emails sent to them. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.6.2 / LibreOffice Community Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Created attachment 186143 [details] screen shot of failing email merge. I am aware that this is actually and long term and persistently reported bug, but it would have been very convenient to send these emails using LibreOffice. I'll have to figure out how to do it in gmail now.
Thank you, John. Yes, please send example files for us to test the issue. Where did you see the information about incrementing the numbers? What happens if you don't?
It hangs no matter what I do with the numbers. I never got it to successfully complete the email merge process. But it got close. I'll attach the template.
Created attachment 186172 [details] Template that I used. This should be the template that I used.
Created attachment 186173 [details] Spreadsheet with Dummy data, it hangs too. I notice that I have the Template and Spreadsheet in Microsoft format (.docx and .xlsx), trying to keep it in format that my team members can use.
Created attachment 186174 [details] There hang message. After a while, this is the message I got. Hitting wait doesn't seem to help as it just comes back again.
[Automated Action] NeedInfo-To-Unconfirmed
Thanks for the extra attachments, John. I did not get stuck at that dialog, I could go through the steps and send the emails (maybe you received them?). I used: - Tools > Address Book Source > Assign > Other external data source > Next > Settings > Spreadsheet, filled in the path to the XLSX you attached > Finish - Back in Data Source dialog, Next > Finish. - Used that new data source in Address Book Assignment - Clicked Send Email Messages, used the default settings (send all documents, not using the incremented number) Version: 7.4.6.2 / LibreOffice Community Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Did you use a different method for the data source?
Question, were you working from a Linux / Ubuntu system. I assume you were working from the same version that I'm using. (7.4.6.2 I think). Do you have any suggestions about things that I can check or upgrade or uninstall/reinstall?
I brought up the Template I clicked on Edit and then Exchange Database. I chose my Database and Table. I clicked on Send Email icon. Set it to email address Set subject Click on Send Documents Got windows saying Status Creating Documents and it processed all 6 documents and then it hung. A while later I got the Force or Wait options. (In reply to Stéphane Guillou (stragu) from comment #8) > Thanks for the extra attachments, John. > > I did not get stuck at that dialog, I could go through the steps and send > the emails (maybe you received them?). > > I used: > - Tools > Address Book Source > Assign > Other external data source > Next > > Settings > Spreadsheet, filled in the path to the XLSX you attached > Finish > - Back in Data Source dialog, Next > Finish. > - Used that new data source in Address Book Assignment > - Clicked Send Email Messages, used the default settings (send all > documents, not using the incremented number) > > Version: 7.4.6.2 / LibreOffice Community > Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d > CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 > Locale: en-AU (en_AU.UTF-8); UI: en-US > Calc: threaded > > Did you use a different method for the data source?
Thank you for the example documents and the steps. I could reproduce LO hanging once it reaches the progress of "6 of 6", then the "force quit" message keeps popping up. Reproduced in: - 7.3.7.2: https://crashreport.libreoffice.org/stats/crash_details/93bc5669-05a0-4aa0-861e-2ccc273f20c9 - 7.4.6.2: https://crashreport.libreoffice.org/stats/crash_details/2d3a69aa-0003-44c9-a410-a523705c247d - 7.5.2.2: https://crashreport.libreoffice.org/stats/crash_details/93bc5669-05a0-4aa0-861e-2ccc273f20c9 And in a recent master build: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 23bd3bd10e74b0c23c2654d02d7d830e7693adac CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded In 7.2, the buttons remain greyed out after doing the database exchange, so not sure if it is a regression or not. I checked that my email account settings were correct by doing a successful mail merge from scratch, also using an XLSX file to store the email addresses. So there is something happening with the particular document / spreadsheet you are using.