3 Replies Latest reply on Aug 9, 2006 6:56 AM by Dan Bracuk


    JohnGree Level 1
      hi i have a database of 1000 email addresses who are members, if i use cfmail using the code below, is the a way to diplay all the addresses cfmail looped through? just so i know cfmail worked to all addresses?

      <cfquery name="emaillist" datasource="iluvcricket">
      SELECT *
      FROM Main_Clubs_Data
      WHERE Email is not null

      <cfmail to = "craig@cm-website-designs.com.au"
      from = "Admin@iluvcricket.com.au"
      subject = "ggg" query="emaillist"
      FAILTO = "craig@cm-website-designs.com.au">
      <cfmailparam name="X-Priority" value="1">
      <cfmailparam name="X-MSMail-Priority" value="High">
        • 1. Re: cfmail
          dempster Level 1
          If you put CFMAIL inside a CFOUTPUT from your query, you can display the emails on the screen as they are sent or else add them to a variable and then email the information to yourself.
          • 2. Re: cfmail
            JohnGree Level 1
            hi thanks

            i wud really like to have a email sent to myself with the email that were sent, what wud the code be for setting these variables, do i have to use loop?
            • 3. Re: cfmail
              Dan Bracuk Level 5
              cfmail does not send mail. It puts files in a spool directory. From there, either the mail gets sent and the files disappear, or the files go to an undelivered directory. In some, if not all cases, the person in the "from" attribute, will get notified in the mail is not sent.

              Another approach might be to assume all the mail was sent, unless informed otherwise.