Eric,
Take a look a the "Sending query-based email" on this page
http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec14b97-7ffb.html
You specify the query name in the query attribute and the email column as
your "To:" attribute. Cfmail will then loop over the query and send a
customized email to each record in the query.
On Sun, Dec 2, 2012 at 5:45 PM, Matt Quackenbush <quackfu...@gmail.com>wrote:
>
> No need at all for the cfloop. When you provide the query to cfmail it does
> the loop for you.
>
>
> On Sun, Dec 2, 2012 at 4:35 PM, Eric Bourland <e...@ebwebwork.com> wrote:
>
> >
> > Matt, thanks for that. I made progress. I read up on the query attribute
> of
> > CFMAIL. But after doing some research, I did find another way to make
> this
> > application work: CFLOOP. This seems to be working fine -- but do you
> > recommend another way? I could not figure out how the query attribute of
> > CFMAIL would help me in this case -- I am sure I am just missing
> something
> > very obvious. =) Thank you again for your help. Eric
> >
> > <!--- is form.doRemind defined? --->
> > <cfif IsDefined("FORM.doRemind")>
> >
> > <!--- begin to loop through query --->
> > <cfloop query="NotPaid">
> >
> > <cfmail
> > server="#REQUEST.MailingListServer#"
> > from="i...@nnvawi.org"
> > to="#NotPaid.UserEmail#"
> > subject="NNVAWI Membership Dues Reminder"
> > username = "username"
> > password = "#REQUEST.MailingListAdminPass#"
> > SpoolEnable="No"
> > type="html">
> >
> > <h1>Greetings, #NotPaid.FirstName# #NotPaid.LastName#.</h1>
> >
> > <p>This is a friendly reminder to pay your NNVAWI membership dues
> for
> > the current year. You may do so here at the secure authorize.net payment
> > page:
> >
> > </cfmail>
> >
> > </cfloop>
> > <!--- close cfloop --->
> >
> > </cfif>
> > <!--- / is form.doRemind defined? --->
> >
> > -----Original Message-----
> > From: Matt Quackenbush [mailto:quackfu...@gmail.com]
> > Sent: Sunday, December 02, 2012 4:16 PM
> > To: cf-talk
> > Subject: Re: question about lists and CFMAIL
> >
> > No, not on the right track. Look at the query attribute of <cfmail>.
> That's
> > what you want to use.
> >
> >
> >
> http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e08
> > 11cbec22c24-7f8e.html
> >
> > HTH
> >
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353328
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
