I created in Calc a list of persons with their e-mail adres. This includes myself.
In Writer I composed a document with reference to the calc file, and have my provider’s smtp settings for my own emailadress, and that tested OK in the LO Writer options.
Now I send the mails and they go through, I know because:
two addresses were rejected as invalid (my fault)
and
someone reacted to the mail.
But I notice two things:
The mails sent do not appear in my Sent folder
and
I don’t see my own mail coming in at my own mail adddress.
Is this behavior to be expected or not?
indeed, no reason.
Checked the ods file again for a typo in the address, but it looks OK.
I can live with the situation, but sending a mail to oneself is something users do to see the mail has effectively gone thru.
If you judge it necessary, I’m willing to raise a bug, or leave it alone for now.
sounds more like a config from your SMTP server, than something LO related.
you can try tweaking the entry like : “whatever” <your@actual.email>
and see how it goes
Only you can check if that’s a problem or not.
- Copying mails to your “sent” folder is either a setting of your mailer agent (like Thunderbird), or of your mail server account. LibreOffice doesn’t use your mailer client when doing mail merge. In any way, not appearing in “sent” is not a LibreOffice problem.
- You may want to check logs of your SMTP server, to see if the expected mails are attempted to be sent, and if so, why some get rejected (?).
- You may also want to debug the mailer implementation used in mail merge. It’s a Python script; you may find it in
<LibreOffice instdir>/program/mailmerge.py
. It even hasdbg
variable, set tofalse
by default, but which you can change totrue
, and also you may add whatever output you need. Running LibreOffice from a console then would provide all the mail merge logging to that console.
pt 1. LO does not use my mailer agent , that is clear. So I’m at lost how to see that the mails actually went thru. I contacted py provider, wait and see.
pt 2. I don’t have access to the log files of my provider, I do not run a SMTP server locally.
pt 3. I’ll keep that in mind on a next occasion.
And BTW, not seeing my own maill coming in, that I can now explain: I went to the webmail of my provider and there I found the mail in my SPAM folder. Should have lookedearlier.
If you are using some form of Linux then you might see if there is some logging, perhaps /var/log/maillog or similar. You may be able to confirm where your system logs mail traffic from the setting in /etc/syslog.conf
I am on Linux Mageia 9, but not running a mail service myself, I use the SMTP seerver of my provider, so there is no logging in my local desktop.
on pt 3., just running the command to be suren it’s OK even when no mailing is being done:
$ python3 ./mailmerge.py
Traceback (most recent call last):
File "/opt/libreoffice24.8/program/./mailmerge.py", line 24, in <module>
from com.sun.star.mail import XMailServiceProvider
File "/opt/libreoffice24.8/program/uno.py", line 425, in _uno_import
raise uno_import_exc
File "/opt/libreoffice24.8/program/uno.py", line 346, in _uno_import
return _builtin_import(name, *optargs, **kwargs)
ImportError: No module named 'com' (or 'com.sun.star.mail.XMailServiceProvider' is unknown)
I don’t remember telling you to run that file manually. IIRC, I only wrote to launch LibreOffice from console:
LibreOffice uses that code internally itself.
OK, run with a smaller sample of 15 adresses with success, but output on the CLI is quite frugal.
$ libreoffice24.8
Could not find platform independent libraries <prefix>
Could not find platform dependent libraries <exec_prefix>
Consider setting $PYTHONHOME to <prefix>[:<exec_prefix>]
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
XSL Vendor: 'libxslt'
It counts to 15, that is OK. I wonder whether I coiuld expect more. But anyway, my main concern was to get the mailmerge working and that is OK.
You seem to not enabled the debug output in that PY file, thus no details could be seen.