Beth, You need to specify the query too or wrap the cfmail in a cfloop of the query.
I don't recommend that specify the query in the cfmail tag. CFMAIL will fall over if you have too many emails go out at once and it can send emails pretty quickly using the query attribute. If you loop round the query, the time taken isn't that much longer, but the extra time does mean that emails get a chance to leave CF and through the mail server without any flooding occuring... Hope this helps Regards Stephen ----- Original Message ----- From: "Beth F" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 6:17 PM Subject: OT: technical CFMail Question > my documentation tells me that using a query column in the "to" parameter will result in the email message being sent for each row returned in that query. > > it doesnt' appear to be working that way - it only seems to send to the first email address. > > here is the code: > <cfmail to="#bulletinemails.email_address#" from="[EMAIL PROTECTED]" subject="ANTHC Job Vacancy Announcement"> > > > Thanks in advance. > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists