Issue 69250 - No Cc and Bcc with mailmerge/email
Summary: No Cc and Bcc with mailmerge/email
Status: CLOSED FIXED
Alias: None
Product: Writer
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.0.3
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: pmladek
QA Contact: issues@sw
URL:
Keywords: oooqa
: 65463 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-09-04 21:05 UTC by jm_mouchel
Modified: 2013-08-07 14:43 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Screen 4 (28.35 KB, application/msword)
2006-09-12 18:56 UTC, jm_mouchel
no flags Details
All attached files in a zip file (126.79 KB, application/msword)
2006-09-12 19:02 UTC, jm_mouchel
no flags Details
two files : mailmerge.py and debug output example. (3.58 KB, application/x-compressed)
2007-01-03 13:58 UTC, jm_mouchel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jm_mouchel 2006-09-04 21:05:34 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
Comment 1 michael.ruess 2006-09-11 14:32:04 UTC
Reassigned to HI.
Comment 2 h.ilter 2006-09-11 15:03:32 UTC
Please give a step by step description, how you've proceeded the mail copies.
From my point of view it works.
Comment 3 jm_mouchel 2006-09-12 18:56:24 UTC
Created attachment 39101 [details]
Screen 4
Comment 4 jm_mouchel 2006-09-12 19:02:38 UTC
Created attachment 39102 [details]
All attached files in a zip file
Comment 5 jm_mouchel 2006-09-12 19:11:50 UTC
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)
Comment 6 h.ilter 2006-09-13 11:22:32 UTC
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.
Comment 7 h.ilter 2006-09-13 11:32:21 UTC
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.
Comment 8 jm_mouchel 2006-09-13 19:45:57 UTC
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
Comment 9 Rainer Bielefeld 2006-12-29 17:32:48 UTC
*** Issue 65463 has been marked as a duplicate of this issue. ***
Comment 10 mouchel 2006-12-30 11:59:48 UTC
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
Comment 11 mouchel 2006-12-30 15:29:02 UTC
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
Comment 12 Rainer Bielefeld 2007-01-03 12:14:23 UTC
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.
Comment 13 jm_mouchel 2007-01-03 13:58:34 UTC
Created attachment 41853 [details]
two files : mailmerge.py and debug output example.
Comment 14 jm_mouchel 2007-01-03 14:14:18 UTC
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.
Comment 15 Rainer Bielefeld 2007-01-03 14:49:21 UTC
'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. 
Comment 16 Oliver Specht 2007-01-10 08:16:04 UTC
->cmc: The error seems to be in the python mail component. 
Is the fix from mouchel correct?
Comment 17 caolanm 2007-01-10 09:53:58 UTC
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
Comment 18 caolanm 2007-01-10 12:32:53 UTC
fix checked into cmcfixes31
Comment 19 caolanm 2007-01-11 16:45:45 UTC
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
Comment 20 pmladek 2007-01-12 09:57:42 UTC
Verified in CWS cmcfixes31.

I can confirm that it did not work with the unpatched mailmerge.py and it works
with the cmcfixes31 build.
Comment 21 ace_dent 2008-05-16 03:28:36 UTC
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 ~