Ben, Post us some code. I think what you're asking is possible, but it would be easier if we could see exactly what you're trying to do.
As for the query attrib of cfmail, this works fine - but in your case, you should use "distinct COLUMN" in your query, for example: SELECT distinct email_address FROM MyTable This would select unique records and email addresses, and stop you from sending duplicate emails to each member. HTH Will -- http://www.localbounty.com/r.cfm?i=msg - free local and national advertising ----- Original Message ----- From: "Ben Densmore" <[EMAIL PROTECTED]> Newsgroups: gradwell.lists.cftalk Sent: Saturday, November 03, 2001 8:48 PM Subject: CFMail Question > Is it possible to use CFMail inside of a cfloop tag that calls a query? > I am doing that to send out 100 emails and it doesn't seem to do > anything. I'm kind of nervous to use the query attribute of the cfmail > tag because I think I remember I tried it once a long time ago and it > sent 100 emails to each of the people I sent it to. Is this true? > > Thanks, > Ben > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
