Trouble with CFMAIL

[khurram]

I am using the CFMAIL tag. I've got the email portion working but now I am having trouble with querying data into the email message.

This is what I have between the the tags:

<CFOUTPUT group=&quot;MainOptionID&quot;>
#MainOptionDescription#<BR>
<CFOUTPUT>
#SubOptionDescription#<BR>
</CFOUTPUT>
</CFOUTPUT>
<CFINCLUDE template=&quot;/webcontent/template/common/emailfooter.cfm&quot;>

If there are nine query results, I receive nine different emails with each item individually in an email. I tried the code for display in HTML and it looks okay.

Any suggestions.

 

[rmz8]

Use the query option of the CFMAIL tag--don't use CFOUTPUT in the actual message. For example, if you wanted to use the query Option, do something like this:

<CFMAIL to=&quot;whatever&quot; from=&quot;whatever&quot; subject=&quot;whatever&quot; query=&quot;Option&quot;>Refer in here to variables in the query named Option.</CFMAIL>

Ryan ;-]