prrvchr / emailerooo Goto Github PK

Hi,
I installed smtpMailer OOo on Libreoffice 7.2.7.
The installation is OK, but when I want to add an expediter, the programm freeze :

Thank you for this application which must allow a mailing from a gmail address
I use LO 7.2.7, OS : windows 10.
the extensions installed are :
smtpmailerOOo 0.0.2
Oauth2OOo 0.0.5
I couldn't install jdbcDriverOOo.oxt
message :
_

(com.sun.star.uno.RuntimeException) { { Message = "[jni_uno bridge error] UNO calling Java method writeRegistryInfo: non-UNO exception occurred: java.lang.UnsupportedClassVersionError: io/github/prrvchr/jdbcdriver/RegistrationHandler has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0\X000ajava stack trace:\X000ajava.lang.UnsupportedClassVersionError: io/github/prrvchr/jdbcdriver/RegistrationHandler has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0\X000d\X000a\X0009at java.lang.ClassLoader.defineClass1(Native Method)\X000d\X000a\X0009at java.lang.ClassLoader.defineClass(Unknown Source)\X000d\X000a\X0009at java.security.SecureClassLoader.defineClass(Unknown Source)\X000d\X000a\X0009at java.net.URLClassLoader.defineClass(Unknown Source)\X000d\X000a\X0009at java.net.URLClassLoader.access$100(Unknown Source)\X000d\X000a\X0009at java.net.URLClassLoader$1.run(Unknown Source)\X000d\X000a\X0009at java.net.URLClassLoader$1.run(Unknown Source)\X000d\X000a\X0009at java.security.AccessController.doPrivileged(Native Method)\X000d\X000a\X0009at java.net.URLClassLoader.findClass(Unknown Source)\X000d\X000a\X0009at java.lang.ClassLoader.loadClass(Unknown Source)\X000d\X000a\X0009at java.lang.ClassLoader.loadClass(Unknown Source)\X000d\X000a\X0009at java.net.FactoryURLClassLoader.loadClass(Unknown Source)\X000d\X000a\X0009at java.lang.ClassLoader.loadClass(Unknown Source)\X000d\X000a\X0009at com.sun.star.comp.loader.RegistrationClassFinder.find(RegistrationClassFinder.java:53)\X000d\X000a\X0009at com.sun.star.comp.loader.JavaLoader.writeRegistryInfo(JavaLoader.java:376)\X000d\X000a", Context = (com.sun.star.uno.XInterface) @0 } }

_
Could you help me ?
Thank you
Christophe

Hello,

I tried an automatic translation with deepL. The result may not be very comprehensible, so I'm adding the original below.

I like your extension, but I can't configure it.
I followed the instructions to install it and everything seems to have worked.
When I try to configure the connection, everything stops at "Configuration found on Mozilla IspDB..."
I'm using a Google Workspace address (with a domain name other than gmail.com). Maybe that's the problem, because with a regular gmail address, I get to the end of the configuration and successfully send a test email.

Second problem (I don't know if they're related): when I click on "publish a document", I can't add a mailing list. The Add button is active, but nothing happens when I click on it. My data source is a free office workbook containing a single sheet. I've added a primary key in the form of an integer in column A. There's a header row.

I don't know what information to add, but I'll answer your questions.
Thank you for your work and your answers.

Translated with www.DeepL.com/Translator (free version)

Bonjour,

J'ai essayé une traduction automatique avec deepL. Le résultat n'est peut-être pas très compréhensible, alors je rajoute en dessous l'original.

Votre extension me plaît bien, mais je n'arrive pas à la configurer.
J'ai suivi les instructions pour l'installer et tout semble avoir réussi.
Lorsque je tente de configurer la connexion, tout s'arrête à "Configuration trouvée sur Mozilla IspDB..."
J'utilise une adresse Google Workspace (avec un nom de domaine différent de gmail.com). C'est peut-être le problème parce qu'avec une adresse gmail classique, j'arrive au bout de la configuration et j'arrive avec succès à envoyer un email de test.

Deuxième problème (je ne sais pas s'ils sont liés) : lorsque je clique "publiposter un document", je n'arrive pas à ajouter une liste de diffusion. La bouton Ajouter est actif, mais il ne se passe rien quand je clique dessus. Ma source de données est un classeur libre office contenant une seule feuille. J'ai ajouté une clef primaire sous la forme d'un entier en colonne A. Il y a une ligne d'en-tête.

Je ne sais pas quels renseignements ajouter, mais je répondrai à vos questions.
Merci pour votre travail et vos réponses.

I am looking for the possibility to have personalized subject line in mail merge function.

Suppose the data source have a column called subject and I would like to be able to reference this field in the send mail merge dialog, e.g. <subject>. Or generally speaking reference combined fields, e.g.: foo <field1> bar <field2>.

It seems that there is another extension available to provide this feature, but not for LibreOffice: [1].

Another option would be to support this feature in core mail merge feature of LibreOffice.

[1] https://www.mapilab.com/blog/how-to-customize-subject-line-in-mail-merge-toolkit-for-outlook/

smtpMailerOOo (it says in the titlebar) is trying to find configuration for address: [email protected] (one of my many addresses) and has got to "Mozilla IspDB search..." and has not moved from there in over an hour. It should have found GMail's settings quickly but hasn't. Now what?

I finally have managed to get everything installed properly and working ... up to a point. I was rather hoping for some demonstration code and I haven't seen much. I may not be looking in the correct location.

My client already has an application fully built and is not about to make wholesale changes to accommodate a different workflow. I have been asked simply to find an email tool that will talk to GMail via OAuth and bolt that on as simply as possible to the existing code base in place or the previous username/password email client that had been in use before.

Is it impossible simply to create a mail object, populate fields and send as one might do in C# with Microsoft's Mail libraries or via Google Apps Script and GMail? If it is impossible, please point out to me a possible solution.