Um... You are writing grades, names and course info to the email, and you
want them all to get the same message? Unless they all have the same name
and grade, I'd keep it how you have it.
-Cameron
--------------------
Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963
> -----Original Message-----
> From: Jim Watkins [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, July 15, 2001 1:27 PM
> To: CF-Talk
> Subject: Sending one CFMAIL
>
>
> How can I send email from a query so that all the info is in one email
> rather than sending individual e-mails for each person in the query? IOW:
> If 50 people fit the criteria then I get 50 individual e-mails rather than
> one email with all the people. Currently my code is:
>
> <CFMAIL query = "badgrade"
> FROM="Eagle"
> To=#facemail.email#
> Subject="Results"
> TYPE="HTML">
> <b>#lname#, #fname#</b>
> Course: #ssbsect_subj_code# #ssbsect_crse_numb#
> CRN: #sfrstcr_crn#
> Grade: #grades#<br><br>
> </CFMAIL>
>
> Jim Watkins
> http://www.ngtcollege.org
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
