Sending dinamic pages as email attachment

[Edimator]

Hi, i need to send a group of invoices as html-type attachment to a specific email address in a batch proccess through a cfm page.

the invoice index table looks like this :
Invoice No Email

   10000000     hgdsh@mailserver.com 
   10000001     asdff@mailserver.com
   10000002     hhytre@mailserver.com
   10000003     vxcbcvxb@mailserver.com

and the URL for the invoice form is

   [URL unfurl="true"]http://cfserver/invoice.cfm?Invoice=10000000[/URL]

i use CFMAIL, but the option MIMEattach can't execute the URL with params

   <cfquery name=&quot;EmailList&quot; datasource=&quot;something&quot;>
      select invoice, client_email from Invoices
   </cfquery>

    <cfmail 
      query=&quot;EmailList&quot;
      from=&quot;noreplay@email.com&quot; 
      to=&quot;#client_email#&quot; 
      subject=&quot;Your Invoice&quot;>

MIMEAttach=

"[URL unfurl="true"]http://cfserver/invoice.cfm?Invoice=#Invoice#[/URL]

[/code]"
</cfmail>
[/code]

I really apreciate any kind of help

 

[NoWayIsThisInUse]

Here's what you do:
....this could be big loop
<cfmail
from = &quot;you@whatever.com&quot;
to = &quot;#trim(GetEmailAddress.Email)#&quot;
subject = &quot;Subject #Whatever#&quot;
server = &quot;pop3.whatever.com&quot;
type = &quot;HTML&quot;>
...this could be small loop
<cfmailparam
file = &quot;#expandpath('./myFile/#myFile#')#&quot;>
...end of small loop
</cfmail>
...end of big loop