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 be allowed to work as designed for a more narrow purpose without having to work out unusual or creative workarounds for its innate features. If you have to add tweaky things to the CFMAIL tag, which can have enough bugs of it's own, then perhaps executing 2 calls (especially since each call has an entirely different purpose, method, and attribute set) is really the best idea. Laterz, J -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com On Fri, 14 Jan 2005 10:24:48 -0500, Al Everett <[EMAIL PROTECTED]> wrote: > 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 > <[EMAIL PROTECTED]> wrote: > > 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:190449 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