Right... That's why I corrected myself. Robert's solution was correct.
Lee
> -----Original Message-----
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, July 15, 2001 2:03 PM
> To: CF-Talk
> Subject: RE: Sending one CFMAIL
>
>
>
> Wouldn't the other way around send 50 emails, not one? The
> original
> poster only wanted one.
>
>
> At 11:00 AM 07/15/2001 -0700, you wrote:
> >Or the other way around ;)
> >
> >
> >
> > > -----Original Message-----
> > > From: Robert Segal [mailto:[EMAIL PROTECTED]]
> > > Sent: Sunday, July 15, 2001 10:58 AM
> > > To: CF-Talk
> > > Subject: RE: Sending one CFMAIL
> > >
> > >
> > > <CFMAIL FROM="Eagle" To=#facemail.email# Subject="Results"
> > > TYPE="HTML">
> > > <CFLOOP QUERY="BADGRADE">
> > > <b>#lname#, #fname#</b>
> > > Course: #ssbsect_subj_code# #ssbsect_crse_numb#
> > > CRN: #sfrstcr_crn#
> > > Grade: #grades#<br><br>
> > > </CFLOOP>
> > > </CFMAIL>
> > >
> > > -----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