From: Craig77 on
hi i need to include a list items from my table in my email

i have tried the code below but this dosnt work, any ideas how i can do this?

<cfmail type="HTML"
to = "craig_mac(a)bigbutton.com.au"
from = "web(a)dpsguide.com.au"
subject = "Please check you details">
<cfmailparam file="images/EmailLogo.jpg"
disposition="inline"
contentID="image1">

<table>
<cfoutput query="GetDetails">

<tr><td>#GetDetails.FacilityName#</td><td>#GetDetails.OrganisationName#</td></t
r>

</cfoutput></table>
</cfmail>

From: BKBK on
Your code is all right. However, you forgot that cfmail was designed to do
cfoutput automatically, making the placing of cfoutput within cfmail equivalent
to cfoutput-nesting, which is not allowed. Correct is





<cfsavecontent variable="email_content">
<cfoutput query="GetDetails">

<tr><td>#GetDetails.FacilityName#</td><td>#GetDetails.OrganisationName#</td></
tr>
</cfoutput>
</cfsavecontent>
<cfmail type="HTML"
to = "craig_mac(a)bigbutton.com.au"
from = "web(a)dpsguide.com.au"
subject = "Please check you details">
<cfmailparam file="images/EmailLogo.jpg"
disposition="inline"
contentID="image1">
<table>
#email_content#
</cfmail>

From: Craig77 on
ok thanks

thats works i have now added a form with check boxes and text boxes to my
email with default values from my database table which works fine

can i somehow have a submit btn on there so when people recieve my email, they
can update the tick boxes press submit and it would send the email back to me
with the changes they have made?

From: BKBK on
Sure. All depends on how your code cuts it.