Are there size etc. limits to using a MailMerge object?

Creating a macro - Writing a Script - Using the API

Are there size etc. limits to using a MailMerge object?

Postby owlbrudder » Tue Apr 25, 2017 1:19 am

I am using a MailMerge object to send emails to 300 recipients in a club I belong to (don't worry, it is not spam ...).

I ran the code for the first time last night and it crashed after about twenty minutes, after sending an unknown number of emails. I was able to identify a rough end point and tweaked a few hings before restarting. Again, it crashed after about twenty minutes.

The error message just said it was a crash and "There is no further information".

After a sleepless night (this is moderately urgent) I came to the conclusion I may be hitting a hard limit I don't know about. Perhaps disk space reserved for the job by LibreOffice? Perhaps a count of the number of documents sent? Perhaps a timing issue? I have Googled (as always) and found nothing relevant. If there is documentation of such limits, I obviously don't know where to look.

Is this a known bug? How can I debug a problem when the error message says "no further information"?

I am continuing to work on my code in hope I will find a gross stupidity, but have not found one yet.

Incidentally, the merge document contains no fields: the datasource - an .odb linked to a spreadsheet - is used purely for it's 'Email' column where the email addresses are stored (I bet you guessed that...). I am going to run a test using a query returning just the email column, rather than using the table with all its columns, in case that is fouling up the works, but don't hold out much hope of a cure.

Any advice would be greatly appreciated.

Cheers,
Doug
LibreOffice Version: 5.3.1.2-2
Fedora 25 Linux x86_64
Core i7, 8Gb
owlbrudder
 
Posts: 69
Joined: Tue Nov 08, 2016 8:04 am

Re: Are there size etc. limits to using a MailMerge object?

Postby Zizi64 » Tue Apr 25, 2017 6:46 am

And what E-mail client software are you using? (The LibreOffice has not E-mail client function.)
Tibor Kovacs, Hungary; LibreOffice4.4.7 - Portable versions: LO3.3.0-LO5.3.3 and AOO4.1.3; on Win7x64Prof.
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5128
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Are there size etc. limits to using a MailMerge object?

Postby robleyd » Tue Apr 25, 2017 7:01 am

Does your service prover impose any limit on the number of emails that can be sent in a time period?
Cheers
David
OpenOffice 4.1.3 - Slackware 14.2 - 64 bit
User avatar
robleyd
Volunteer
 
Posts: 588
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Are there size etc. limits to using a MailMerge object?

Postby owlbrudder » Tue Apr 25, 2017 7:58 am

Zizi64 wrote:The LibreOffice has not E-mail client function.
Er ... yes it does ... that's what the MailMerge object uses. :)
LibreOffice Version: 5.3.1.2-2
Fedora 25 Linux x86_64
Core i7, 8Gb
owlbrudder
 
Posts: 69
Joined: Tue Nov 08, 2016 8:04 am

Re: Are there size etc. limits to using a MailMerge object?

Postby owlbrudder » Tue Apr 25, 2017 8:39 am

robleyd wrote:Does your service prover impose any limit on the number of emails that can be sent in a time period?
Good question - I will have to enquire. Thanks for the suggestion (shows how tired I am that I did not think of it first ...)
LibreOffice Version: 5.3.1.2-2
Fedora 25 Linux x86_64
Core i7, 8Gb
owlbrudder
 
Posts: 69
Joined: Tue Nov 08, 2016 8:04 am


Return to Macros and UNO API

Who is online

Users browsing this forum: Yahoo [Bot] and 6 guests