I would like to thank all the great responses on this. I elected to do
the separate emails that Jared suggested. Seemed to work best with my
Oracle database.
Jim W
-Original Message-
From: James Watkins [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 7:33 AM
To: CF-Talk
Hey, cool...
Glad to help out!
Laterz,
J
On Tue, 18 Jan 2005 15:18:42 -0500, James Watkins
[EMAIL PROTECTED] wrote:
I would like to thank all the great responses on this. I elected to do
the separate emails that Jared suggested. Seemed to work best with my
Oracle database.
Jim W
Bcc ? ..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Find out how CFTicket can increase your company's
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
From: Calvin Ward [mailto:[EMAIL PROTECTED]
The other solutions aren't as ideal for various reasons, in
my opinion.
What si wrong with the two cfmail tag calls? 1 call passing in the query
and 1 call to the 1 recipient
this might work.
cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address#
from=#mailfrom# subject=Greetings
email body
/cfmail
-Original Message-
From: James Watkins [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 7:33 AM
To: CF-Talk
Subject: CFmail and
]
Sent: Friday, January 14, 2005 7:40 AM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
this might work.
cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address#
from=#mailfrom# subject=Greetings
email body
/cfmail
-Original Message-
From: James Watkins [mailto:[EMAIL
yeah, i thought about that afterwards. ;-)
-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 8:17 AM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
That would display everyone's email to the recipients...
You could also do this:
cfmail
That would also display the address to everyone. You must use bcc for
that... that is why it is called Blind Carbon Copy.
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
BLAH
/CFMAIL
/CFOUTPUT
-Original Message-
From: John Stanley [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 7:40 AM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
this might work.
cfmail to=#valuelist(mail_roster.student)# cc=#your_email_address#
from=#mailfrom
I missed changing that, which was what my actual intention was... so much
for being in a hurry!
-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 8:54 AM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
That would also display
[mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 9:02 AM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
Not sure if it works, but could be something like:
CFOUTPUT QUERY=mail_roster
CFMAIL TO=#student#
FROM=#mailfrom#
BCC=CFIF
Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 3:02 PM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
Not sure if it works, but could be something like:
CFOUTPUT QUERY=mail_roster
CFMAIL TO=#student#
FROM=#mailfrom
From: James Watkins [mailto:[EMAIL PROTECTED]
When sending email to a list of several hundred students
using CFmail I would like to receive just 1 copy of what I
send. How can I modify below to do that?
cfmail query=mail_roster
to = #student#
from = #mailfrom#
Why not add a row to the query before the CFMAIL tag?
cfscript
QueryAddRow(mail_roster,1);
QuerySetCell(mail_roster,student,[EMAIL PROTECTED]);
/cfscript
Downside is, of course, if you use the query result later on your
address is added in.
On Fri, 14 Jan 2005 07:33:13 -0500, James Watkins
Why not simply do this:
cfmail to = #me#
from = #mailfrom#
subject = Greetings
blah, blah
/cfmail
cfmail query=mail_roster
to = #student#
from = #mailfrom#
subject = Greetings
blah, blah
/cfmail
In that case, each cfmail tag is cohesive, in that it can
and receiving 1 copy
Why not add a row to the query before the CFMAIL tag?
cfscript
QueryAddRow(mail_roster,1);
QuerySetCell(mail_roster,student,[EMAIL PROTECTED]);
/cfscript
Downside is, of course, if you use the query result later on your
address is added in.
On Fri, 14 Jan 2005 07:33:13 -0500
True, Calvin... and sometimes you get really great advice!
Sometimes you end up with a mishmash of options that just mean you
know less than you started out with. Gotta love it.
But as a side note, I've done things like all 4 of the below, thinking
I was doing really great stuff by altering the
I did just think of one other option that may not be so bad...
if you init a counter at 0:
cfset counter=0
and then use a conditional loop:
cfloop condition = counter EQ query.recordcount
cfmail to=
Nope, still ain't gonna cut it.
It's a bunch of extra code and work when the functionality
was sent to the other recipients.
The other solutions aren't as ideal for various reasons, in my opinion.
- Calvin
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 11:59 AM
To: CF-Talk
Subject: Re: CFmail and receiving 1 copy
From: Calvin Ward [mailto:[EMAIL PROTECTED]
The other solutions aren't as ideal for various reasons, in
my opinion.
What si wrong with the two cfmail tag calls? 1 call passing in the query
and 1 call to the 1 recipient?
~|
OK, I'll go with you on that one...
And thinking about it again, you don't have to handle the email
content twice, either. You basically extend the concept of recipient
by adding yourself to it.
I've been buried in studying OO these days, so I'm thinking
differently than I did for a long time.
, 2005 1:31 PM
To: CF-Talk
Subject: RE: CFmail and receiving 1 copy
From: Calvin Ward [mailto:[EMAIL PROTECTED]
The other solutions aren't as ideal for various reasons, in
my opinion.
What si wrong with the two cfmail tag calls? 1 call passing in the query
and 1 call to the 1 recipient
There's nothing wrong with two calls to CFMAIL...
In fact, there's still something to be said for letting one call be a
1-to-1 operation and the other call be a query-driven operation,
allowing CFMAIL to do each thing seperately as intended.
But Calvin has a point, in that it makes for 2 points
23 matches
Mail list logo