Apache OpenOffice (AOO) Bugzilla – Issue 69250
No Cc and Bcc with mailmerge/email
Last modified: 2013-08-07 14:43:17 UTC
I am using OOo 2.0.3-7 (French version), mailmerge is ok and works fine, and emails can easily be sent, this is great. But Cc and Bcc seem to fail. I tried to send Cc or Bcc of all sent messages to myself and did not receive any copy. I think it is a serious problem because since sent messages are not sent through the usual mailer, no copy of the sent messages is stored in any kind of "sent" mailbox. JMM
Reassigned to HI.
Please give a step by step description, how you've proceeded the mail copies. From my point of view it works.
Created attachment 39101 [details] Screen 4
Created attachment 39102 [details] All attached files in a zip file
ok, I do again the same test from my laptop, not from by desktop, but the problem is the same. Linux version (laptop) : Linux dellphine 2.6.12 #1 Thu Aug 18 09:19:02 PDT 2005 i686 GNU/Linux I use Openoffice.org 2.0.3 Date in file /opt/openoffice.org2.0/README : $Date de la dernière mise à jour : 10/03/2005 11:26:14 $ (and same version on my desktop at home). I use the "assistant mailing" procedure (sorry, in French) Step 1 : "Document actif" Step 2 : Document type "E-mail" Step 3 : I add the attached ods file as a new database Step 4 : I do nothing Step 6 : I edit the document, which formerly was empty (see the ods file) Step 7 : I check the document created by the mailmerge procedure Step 8 : I send the document by email (see the screen shots) Screenshot 1 : The Cc (to my personal address) Screenshot 2 : sent ok Screenshot 3 : mozilla ; the received e-mail. Screenshot 4 : my java options (no Class Path) Cc looks correct on the screenshot, but I did not recieve any copy of this email. Same if I send the Cc to the main recipient address. In addition to the screenshots, I also attach : - the .ods file used as database - the .odt file used for the mailing - the source of the received email (also looks ok !!) I hope I told enough, please aks for more if needed. All the best, JMM All attachments in a zip file (screen 4 already sent once, sorry, mistake)
HI->OS: used attached database as ods file with two entries. I could reproduce , that the CC of the first recipient seems to be excluded. The CC of the second will be delivered.
Meanwhile I've got also the cc of the first recipient. There is something strange. ->jm_mouchel: What about when you switch the cc and recipient in opposite way? It could be that the provider is the reason for the problem. In summary I have to say that it works.
well.. I tried with several Cc on the Cc line, separated by ";", and to change orders, but the results were the same (no copy). I also tried to remove the automatic transfer from my second email address to the main one in order to have completely different addresses in sender and Cc, but the result was still the same (Cc recipient did not receive the email). I will check with my provider, and try to get an answer. I will also find a way to make the test with another provider, I let you know the results. Thanks JMM
*** Issue 65463 has been marked as a duplicate of this issue. ***
Hi, somebody else encountered the same kind of problem.... May be it is a real problem... Please find below the MTA log report from the server (for the problem described in may previous emails), it shows that the MTA understands only one recipient, even when a Cc is added. Mail server : OS : Debian GNU/Linux sarge MTA: sendmail 8.13.4-3sarge3 Here is the MTA log : Sep 13 20:53:16 cereve sm-mta[21894]: k8DIrEBS021894: from=<mouchel@cereve.enpc.fr>, size=900, class=0, nrcpts=1, msgid=<200609131853.k8DIrEBS021894@cereve.enpc.fr>, proto=ESMTP, daemon=MTA-v4, relay=dhcp177-22-8-48.enpc.fr [172.22.8.48] Sep 13 20:53:16 cereve amavis[21718]: (k8DIrEBS021894) Passed, <mouchel@cereve.enpc.fr> -> <mouchel@cereve.enpc.fr>, Message-ID: , Hits: - Sep 13 20:53:16 cereve sm-mta[21894]: k8DIrEBS021894: Milter change (add): header: X-Virus-Scanned: by amavisd-new Sep 13 20:53:16 cereve sm-mta[21899]: k8DIrEBS021894: to=<mouchel@cereve.enpc.fr>, ctladdr=<mouchel@cereve.enpc.fr> (3802/100), delay=00:00:00, xdelay=00:00:00, mailer=local, pri=31284, dsn=2.0.0, stat=Sent Note that nrcpts=1 ! While the message header (received by mouchel@cereve.enpc.fr) was : Message-Id: <200609131853.k8DIrEBS021894@cereve.enpc.fr> > Subject: toto > From: mouchel@cereve.enpc.fr > To: mouchel@cereve.enpc.fr > Cc: jean-marie.mouchel@wanadoo.fr If the Cc was well understood, sendmail should say nrcpts=2. It seems there is a misfit between the header of the message and its enveloppe(s). JMM
Think I got it ! I very slightly modified "mailmerge.py": # Following line modified by JMM # self.server.sendmail(sender, recipients, msg.as_string()) self.server.sendmail(sender, truerecipients, msg.as_string()) Seems to be ok. Cheers, JMM
I did some tests with "2.0.2 German version WIN XP: [680m5(Build9011)]" and saw 2 DIFFERENT problems: 1. Missing BCC I sent an E-Mail mail merge letter with a BCC, but without CC. In the mails I received no BCC was visible, not in the 'Seamonkey' heading display and even not in the mail source code. 2. CC does not work When I inserted a CC address, I see it in the 'Seamonkey' heading display and also in the mail source code. But it does not work, at least not with my mail provider "All-Inkl" (http://www.all-inkl.com/). T compared with a CC-mail created with my sea monkey and found out: Cc: RainerBielefeld_OOo_QA@bielefeldundbuss.de does not work CC: RainerBielefeld_OOo_QA@bielefeldundbuss.de works But of course, also other effects in the mail header can cause the misfunction, I will contact my provider and report the results here.
Created attachment 41853 [details] two files : mailmerge.py and debug output example.
Comments regarding the previous attachement. I turned on the debug option of mailmerge.py. Attached files are the modified mailmerge.py and the debug output. I sent three time the same message with the Oo mailer assistant to my three addresses : mouchel@cereve.enpc.fr jean-marie.mouchel@ccr.jussieu.fr jean-marie.mouchel@wanadoo.fr With copy to mouchel@cereve.enpc.fr and hidden copy to jean-marie-mouchel@ccr.jussieu.fr for all messages. The debug file shows what hapenned. All what had to be sent was sent (and I also reveived it). Of course, the email was only sent once when the main recipient and the CC or BCC where the same. mailmerge creates a "CC" line in the message header (which you can read in the message source). To have a "Cc" instead of "CC", you should uncomment line 150 and comment line 151 in mailmerge.py. My mail reader (mozilla) recognizes both CC and Cc in headers. mailmerge does not create any BCC line in the message header (which is part of the message and sent to all recipients). Indeed it should not do so, because BCC must remain hidden recipients. However, the message is sent to the BCC recipient. Happy New Year.
'jm_mouchel' is right, what a nonsense to search for a BCC line in the source :-/ But: for me the BCC did not work, I only got the mails to the normal recipient, never to the BCC address.
->cmc: The error seems to be in the python mail component. Is the fix from mouchel correct?
hum ho, so I went to quite a bit of effort to get the truerecipients and then just used it for the debug output and not actually for the sending of the mail. Not smart. mouchel is totally right of course
fix checked into cmcfixes31
This can only be verified by someone using the openoffice.org build rather than the staroffice one. http://ooo.services.openoffice.org/pub/OpenOffice.org/cws/upload/cmcfixes31/ cmc->pmladek: do you think you could verify this. I think I remember you played with this before
Verified in CWS cmcfixes31. I can confirm that it did not work with the unpatched mailmerge.py and it works with the cmcfixes31 build.
This Issue is 'Verified' and not updated in 1yr+, so Closing. A Closed Issue is a Happy Issue (TM). Regards, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~