try this
<CFMAIL QUERY="mail_roster"
TO="#mail_roster.student#"
FROM="#mailfrom#"
BCC="#IIf(mail_roster.current_row is
1,sendOnetoMe,DE(""))#"
SUBJECT="Greetings">
BLAH BLAH BLAH
</CFMAIL>
/t
>-----Original 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#"
> BCC="<CFIF mail_roster.current_row EQ
>1>#sendOnetoMe#</CFIF>">
> SUBJECT="Greetings">
>
> BLAH BLAH 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#" 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 receiving 1 copy
>
>
>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#"
> subject = "Greetings">
> blah, blah
></cfmail>
>
>
>
>Jim Watkins
>Vice President of
>Technology & Institutional Services
>
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190433
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54