Bug 155299

Summary: Enhancement: E-Mail by using mail-merge needs handling of: "messages per connection"
Product: LibreOffice Reporter: RalfK <im030531>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: dgp-mail, heiko.tietze
Priority: medium    
Version: 7.3.6.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 102998    

Description RalfK 2023-05-14 14:15:57 UTC 
Description:
Hi,
I was able to create a mail merge document sending a pdf-attachment to about 150 recipients.
But my internet provider allows sending only 20 messages within on SMTP-connection. Trying to sent to all 150 recipients will fail, starting with number 21...
Sending in peaces of maximum 20 recipients (1-20, 21-40, 41...)is working.



Steps to Reproduce:
1.sending a mail-merge-email to more recipients your internet service provider allow to sent in one smtp-connection.
2.
3.

Actual Results:
reject messages starting by message number <maximum recipients per connection> + 1

Expected Results:
the mail-merge-email dialog should request a value for <maximum recipients per connection>.
the mail-merge process should establish a smtp-connection and send maximum messages defined by <maximum recipients per connection>
then the smtp-connection should be dropped and reestablished for sending the next number(<maximum recipients per connection>) of outstanding message.


Reproducible: Always


User Profile Reset: No

Additional Info:
By the way:
sending messages after messages manually, every time the complete sending dialog  has to filled out from scratch.
Wouldn't it be smarter to prefill the information from the session before?

Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 6; OS: Linux 5.15; 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.2
Calc: threaded
Comment 1 Dieter 2023-06-03 10:48:37 UTC 
Ralf, thank you for your request. Use case seems to be very special but let's ask design-team about their opinion.

cc: Design-Team
Comment 2 Heiko Tietze 2023-06-05 08:20:13 UTC 
Mass email is usually send to all recipients in BCC and not one by one. But you loose the personalization, of course.

I could imagine that provider use an increasing period like 10 seconds after the first 20 messages, but 1 minutes after 40, and 1 hour after 60 etc. just to block this potential spamming. So the suggested option is becoming complex.
Comment 3 Mike Kaganski 2023-06-05 08:31:22 UTC 
(In reply to Heiko Tietze from comment #2)
> Mass email is usually send to all recipients in BCC and not one by one. But
> you loose the personalization, of course.

How is this relevant to the Mail Merge, which is, *by definition*, about sending personalized mails? IMO, unrelated comments only clutter issues, making them less manageable.

Indeed, this is a reasonable request. I had a feeling that we had something similar, but can't find at the moment -> NEW.
Comment 4 Mike Kaganski 2023-06-05 08:48:29 UTC 
(In reply to RalfK from comment #0)
> By the way:
> sending messages after messages manually, every time the complete sending
> dialog  has to filled out from scratch.
> Wouldn't it be smarter to prefill the information from the session before?

It is bug 149703 (and similar bug 144771).
Comment 5 Heiko Tietze 2023-06-19 09:43:13 UTC 
We discussed the topic in the design meeting and suggest to add a GtkFrame "Options" at Tools > Options > Writer > Mail Merge with a checkbox
 
" [ ] Break every [ 100] messages for [  5] s" 

(the actual values could need a review).