Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
generate attachment in CFMAIL, please help
- Thread starter kuolung
- Start date
HI,
I've never tested this but in theory you should be able to use <CFFILE Action="write"
File="C:\temp\temp.html"
output=" #MYHTMLCONTENT# ">
to create the HTML file then attatch it with <CFMAIL ...
The only problem I can see with this is picking a file name. depending on how many people could be using this application you might need to make a filename system like:
temp#CFID#.html
so that each person would have there own temp html file to Attatch.
Hope it helps.
I've never tested this but in theory you should be able to use <CFFILE Action="write"
File="C:\temp\temp.html"
output=" #MYHTMLCONTENT# ">
to create the HTML file then attatch it with <CFMAIL ...
The only problem I can see with this is picking a file name. depending on how many people could be using this application you might need to make a filename system like:
temp#CFID#.html
so that each person would have there own temp html file to Attatch.
Hope it helps.
- Thread starter
- #3
tlhawkins,
thanks for replying. However, i'm lost here. for example, this is what i have:
<cfmail to="#emailQry.email#"
from="#v_from#"
subject="#v_subject#"
server="#smtp_server#"
type="HTML">
Hello <b>#emailQry.email#</b><br>
<p>This is your class schedule</p>:
<table>
</table>.....
.....
</cfmail>
where do i put CFFILE tag?? I was guessing it should be out the CFMAIL,
what about the output content, how do specify that #MYHTMLCONTEN# variable that you gave in your example???
pls help me out. thanks.
thanks for replying. However, i'm lost here. for example, this is what i have:
<cfmail to="#emailQry.email#"
from="#v_from#"
subject="#v_subject#"
server="#smtp_server#"
type="HTML">
Hello <b>#emailQry.email#</b><br>
<p>This is your class schedule</p>:
<table>
</table>.....
.....
</cfmail>
where do i put CFFILE tag?? I was guessing it should be out the CFMAIL,
what about the output content, how do specify that #MYHTMLCONTEN# variable that you gave in your example???
pls help me out. thanks.
I think I understand the question.
I shouldn't have used #MYHTMLCONTENT#
Do this:
<CFFILE Action="Append"
File="d:\http\pb-solutions_com\travs\test1.html"
output="<TABLE border=1
cellpadding=0
cellspacing=0>">
<CFOUTPUT query="MyQuery">
<CFFILE Action="Append"
File="d:\http\mydir\temp.html"
output="<TR> <td> #QUeryData#, #QueryData2#</td> </tr>"
>
</CFOUTPUT>
<CFFILE Action="Append"
File="d:\http\pb-solutions_com\travs\test1.html"
output="</Table>">
That will do a simple table with your Query Data. It's a little anoying but it works.
Just be careful of quotes inside the output =" " string, change them to ' .
The idea is to put the <CFFILE action="Append" ...> Wherever you would have put the formatting for the data that you would have put on the screen. Put the formatting and data instead into the output = " ..." string.
This works for me. I hope I got the right question this time.
I shouldn't have used #MYHTMLCONTENT#
Do this:
<CFFILE Action="Append"
File="d:\http\pb-solutions_com\travs\test1.html"
output="<TABLE border=1
cellpadding=0
cellspacing=0>">
<CFOUTPUT query="MyQuery">
<CFFILE Action="Append"
File="d:\http\mydir\temp.html"
output="<TR> <td> #QUeryData#, #QueryData2#</td> </tr>"
>
</CFOUTPUT>
<CFFILE Action="Append"
File="d:\http\pb-solutions_com\travs\test1.html"
output="</Table>">
That will do a simple table with your Query Data. It's a little anoying but it works.
Just be careful of quotes inside the output =" " string, change them to ' .
The idea is to put the <CFFILE action="Append" ...> Wherever you would have put the formatting for the data that you would have put on the screen. Put the formatting and data instead into the output = " ..." string.
This works for me. I hope I got the right question this time.
1) If you uses Coldfusion server 4, you can make only one attachment. Use the 'mimeAttach' attribute of CFMAIL
<cfmail to="#emailQry.email#"
from="#v_from#"
subject="#v_subject#"
server="#smtp_server#"
type="HTML"
mimeAttach="C:\temp\temp.html">
Hello <b>#emailQry.email#</b><br>
<p>This is your class schedule</p>:
<table>
</table>.....
.....
</cfmail>
2) If you uses Coldfusion server 4.5, you can make several attachments. Use the new tag <CFMAILPARAM FILE="file_name">.
<cfmail to="#emailQry.email#"
from="#v_from#"
subject="#v_subject#"
server="#smtp_server#"
type="HTML">
<cfmailparam file="C:\temp\temp.html">
<cfmailparam file="C:\temp\temp2.html">
Hello <b>#emailQry.email#</b><br>
<p>This is your class schedule</p>:
<table>
</table>.....
.....
</cfmail>
<cfmail to="#emailQry.email#"
from="#v_from#"
subject="#v_subject#"
server="#smtp_server#"
type="HTML"
mimeAttach="C:\temp\temp.html">
Hello <b>#emailQry.email#</b><br>
<p>This is your class schedule</p>:
<table>
</table>.....
.....
</cfmail>
2) If you uses Coldfusion server 4.5, you can make several attachments. Use the new tag <CFMAILPARAM FILE="file_name">.
<cfmail to="#emailQry.email#"
from="#v_from#"
subject="#v_subject#"
server="#smtp_server#"
type="HTML">
<cfmailparam file="C:\temp\temp.html">
<cfmailparam file="C:\temp\temp2.html">
Hello <b>#emailQry.email#</b><br>
<p>This is your class schedule</p>:
<table>
</table>.....
.....
</cfmail>
You should also check out the CFX_iMSMAIL tag here ...
In my opinion, a much better tag.
With it you have complete control over all headers which would allow you to do something like this ...
<!--- convert message to base64 first --->
<cfset CRLF=CHR(13)&CHR(10)>
<cfset MaxWidthPos=72>
<cfset htmlattach=ToBase64(html)>
<cfloop condition="#MaxWidthPos# LTE #len(htmlattach)#">
<cfset htmlattach=insert(CRLF,htmlattach,MaxWidthPos)>
<cfset MaxWidthPos=MaxWidthPos+74>
</cfloop>
then in your message header ...
...
Content-Type: multipart/mixed; boundary="----Next_Part"
...
------Next_Part
Content type: text/html
charset=us-ascii
Content-Transfer-Encoding: 7bit
#html#
------Next_Part
Content-Type: text/html;
name="WhateverYouWantToCallIt.html"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="WhateverYouWantToCallIt.html"
#htmlattach#
------Next_Part--
HTH,
Marc
In my opinion, a much better tag.
With it you have complete control over all headers which would allow you to do something like this ...
<!--- convert message to base64 first --->
<cfset CRLF=CHR(13)&CHR(10)>
<cfset MaxWidthPos=72>
<cfset htmlattach=ToBase64(html)>
<cfloop condition="#MaxWidthPos# LTE #len(htmlattach)#">
<cfset htmlattach=insert(CRLF,htmlattach,MaxWidthPos)>
<cfset MaxWidthPos=MaxWidthPos+74>
</cfloop>
then in your message header ...
...
Content-Type: multipart/mixed; boundary="----Next_Part"
...
------Next_Part
Content type: text/html
charset=us-ascii
Content-Transfer-Encoding: 7bit
#html#
------Next_Part
Content-Type: text/html;
name="WhateverYouWantToCallIt.html"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="WhateverYouWantToCallIt.html"
#htmlattach#
------Next_Part--
HTH,
Marc
- Status