cfmail with attachment

2006-07-08 Thread John Lucania
I need to run this on the Scheduled Task daily.

bla...

   cfcontent type=application/vnd.ms-excel
 table
 tr
   themployee/th
   thfirstname/th
   thmiddlename/th
   thlastname/th
   thaddr1/th
   thaddr2/th
   thcity/th
   thstate/th
   thzip/th
   thhmphonenbr/th
   thdatehired/th
   thtermdate/th
   thdepartment/th
   thdepartmen2/th
   thjobcode/th
   thjobdescrip/th
   thempstatus/th
   themergconta/th
   themergphone/th
 /tr
 cfoutput query=GetSourceDemoInfo
   tr
   td#myemployee#/td
   td#myfirstname#/td
   td#mymiddlename#/td
   td#mylastname#/td
   td#myaddr1#/td
   td#myaddr2#/td
   td#mycity#/td
   td#mystate#/td
   td#myzip#/td
   td#myhmphonenbr#/td
   td#mydatehired#/td
   td#mytermdate#/td
   td#mydepartment#/td
   td#mydepartmen2#/td
   td#myjobcode#/td
   td#myjobdescrip#/td
   td#myempstatus#/td
   td#myemergconta#/td
   td#myemergphone#/td
   /tr
 /cfoutput
 /table

bla...

How do you save the result onto a directory as an Excel file?
Also, how do you e-mail this file as an attachment?

tia

jl

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245806
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: cfmail with attachment

2006-07-08 Thread Snake
Wrap it in cfsavecontent, then use cffile to save it.
Then use cfmail to mail it.

snake 

-Original Message-
From: John Lucania [mailto:[EMAIL PROTECTED] 
Sent: 08 July 2006 17:54
To: CF-Talk
Subject: cfmail with attachment

I need to run this on the Scheduled Task daily.

bla...

   cfcontent type=application/vnd.ms-excel
 table
 tr
   themployee/th
   thfirstname/th
   thmiddlename/th
   thlastname/th
   thaddr1/th
   thaddr2/th
   thcity/th
   thstate/th
   thzip/th
   thhmphonenbr/th
   thdatehired/th
   thtermdate/th
   thdepartment/th
   thdepartmen2/th
   thjobcode/th
   thjobdescrip/th
   thempstatus/th
   themergconta/th
   themergphone/th
 /tr
 cfoutput query=GetSourceDemoInfo
   tr
   td#myemployee#/td
   td#myfirstname#/td
   td#mymiddlename#/td
   td#mylastname#/td
   td#myaddr1#/td
   td#myaddr2#/td
   td#mycity#/td
   td#mystate#/td
   td#myzip#/td
   td#myhmphonenbr#/td
   td#mydatehired#/td
   td#mytermdate#/td
   td#mydepartment#/td
   td#mydepartmen2#/td
   td#myjobcode#/td
   td#myjobdescrip#/td
   td#myempstatus#/td
   td#myemergconta#/td
   td#myemergphone#/td
   /tr
 /cfoutput
 /table

bla...

How do you save the result onto a directory as an Excel file?
Also, how do you e-mail this file as an attachment?

tia

jl



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245807
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfmail with attachment

2006-07-08 Thread John Lucania
snake,

The file name is TPHRDataExtractGet.xls.  How do you attach it in cfmail??

jl

On 7/8/06, Snake [EMAIL PROTECTED] wrote:
 Wrap it in cfsavecontent, then use cffile to save it.
 Then use cfmail to mail it.

 snake

 -Original Message-
 From: John Lucania [mailto:[EMAIL PROTECTED]
 Sent: 08 July 2006 17:54
 To: CF-Talk
 Subject: cfmail with attachment

 I need to run this on the Scheduled Task daily.

 bla...

   cfcontent type=application/vnd.ms-excel
 table
 tr
   themployee/th
   thfirstname/th
   thmiddlename/th
   thlastname/th
   thaddr1/th
   thaddr2/th
   thcity/th
   thstate/th
   thzip/th
   thhmphonenbr/th
   thdatehired/th
   thtermdate/th
   thdepartment/th
   thdepartmen2/th
   thjobcode/th
   thjobdescrip/th
   thempstatus/th
   themergconta/th
   themergphone/th
 /tr
 cfoutput query=GetSourceDemoInfo
   tr
   td#myemployee#/td
   td#myfirstname#/td
   td#mymiddlename#/td
   td#mylastname#/td
   td#myaddr1#/td
   td#myaddr2#/td
   td#mycity#/td
   td#mystate#/td
   td#myzip#/td
   td#myhmphonenbr#/td
   td#mydatehired#/td
   td#mytermdate#/td
   td#mydepartment#/td
   td#mydepartmen2#/td
   td#myjobcode#/td
   td#myjobdescrip#/td
   td#myempstatus#/td
   td#myemergconta#/td
   td#myemergphone#/td
   /tr
 /cfoutput
 /table

 bla...

 How do you save the result onto a directory as an Excel file?
 Also, how do you e-mail this file as an attachment?

 tia

 jl



 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245826
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfmail with attachment

2006-07-08 Thread Daniel Kang
John,

cfmailparam file=TPHRDataExtractGet.xls

Hope this helps!

Daniel

On 7/8/06, John Lucania [EMAIL PROTECTED] wrote:
 snake,

 The file name is TPHRDataExtractGet.xls.  How do you attach it in cfmail??

 jl

 On 7/8/06, Snake [EMAIL PROTECTED] wrote:
  Wrap it in cfsavecontent, then use cffile to save it.
  Then use cfmail to mail it.
 
  snake
 
  -Original Message-
  From: John Lucania [mailto:[EMAIL PROTECTED]
  Sent: 08 July 2006 17:54
  To: CF-Talk
  Subject: cfmail with attachment
 
  I need to run this on the Scheduled Task daily.
 
  bla...
 
cfcontent type=application/vnd.ms-excel
  table
  tr
themployee/th
thfirstname/th
thmiddlename/th
thlastname/th
thaddr1/th
thaddr2/th
thcity/th
thstate/th
thzip/th
thhmphonenbr/th
thdatehired/th
thtermdate/th
thdepartment/th
thdepartmen2/th
thjobcode/th
thjobdescrip/th
thempstatus/th
themergconta/th
themergphone/th
  /tr
  cfoutput query=GetSourceDemoInfo
tr
td#myemployee#/td
td#myfirstname#/td
td#mymiddlename#/td
td#mylastname#/td
td#myaddr1#/td
td#myaddr2#/td
td#mycity#/td
td#mystate#/td
td#myzip#/td
td#myhmphonenbr#/td
td#mydatehired#/td
td#mytermdate#/td
td#mydepartment#/td
td#mydepartmen2#/td
td#myjobcode#/td
td#myjobdescrip#/td
td#myempstatus#/td
td#myemergconta#/td
td#myemergphone#/td
/tr
  /cfoutput
  /table
 
  bla...
 
  How do you save the result onto a directory as an Excel file?
  Also, how do you e-mail this file as an attachment?
 
  tia
 
  jl
 
 
 
 

 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245827
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: cfmail with attachment

2006-07-08 Thread Coldfusion
Make sure you specify the complete path to the file 

-Original Message-
From: Daniel Kang [mailto:[EMAIL PROTECTED] 
Sent: Saturday, July 08, 2006 10:12 PM
To: CF-Talk
Subject: Re: cfmail with attachment

John,

cfmailparam file=TPHRDataExtractGet.xls

Hope this helps!

Daniel

On 7/8/06, John Lucania [EMAIL PROTECTED] wrote:
 snake,

 The file name is TPHRDataExtractGet.xls.  How do you attach it in
cfmail??

 jl

 On 7/8/06, Snake [EMAIL PROTECTED] wrote:
  Wrap it in cfsavecontent, then use cffile to save it.
  Then use cfmail to mail it.
 
  snake
 
  -Original Message-
  From: John Lucania [mailto:[EMAIL PROTECTED]
  Sent: 08 July 2006 17:54
  To: CF-Talk
  Subject: cfmail with attachment
 
  I need to run this on the Scheduled Task daily.
 
  bla...
 
cfcontent type=application/vnd.ms-excel
  table
  tr
themployee/th
thfirstname/th
thmiddlename/th
thlastname/th
thaddr1/th
thaddr2/th
thcity/th
thstate/th
thzip/th
thhmphonenbr/th
thdatehired/th
thtermdate/th
thdepartment/th
thdepartmen2/th
thjobcode/th
thjobdescrip/th
thempstatus/th
themergconta/th
themergphone/th
  /tr
  cfoutput query=GetSourceDemoInfo
tr
td#myemployee#/td
td#myfirstname#/td
td#mymiddlename#/td
td#mylastname#/td
td#myaddr1#/td
td#myaddr2#/td
td#mycity#/td
td#mystate#/td
td#myzip#/td
td#myhmphonenbr#/td
td#mydatehired#/td
td#mytermdate#/td
td#mydepartment#/td
td#mydepartmen2#/td
td#myjobcode#/td
td#myjobdescrip#/td
td#myempstatus#/td
td#myemergconta#/td
td#myemergphone#/td
/tr
  /cfoutput
  /table
 
  bla...
 
  How do you save the result onto a directory as an Excel file?
  Also, how do you e-mail this file as an attachment?
 
  tia
 
  jl
 
 
 
 

 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245828
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfmail with attachment

2006-07-08 Thread John Lucania
Super, Daniel!

John

On 7/8/06, Daniel Kang [EMAIL PROTECTED] wrote:
 John,

 cfmailparam file=TPHRDataExtractGet.xls

 Hope this helps!

 Daniel

 On 7/8/06, John Lucania [EMAIL PROTECTED] wrote:
  snake,
 
  The file name is TPHRDataExtractGet.xls.  How do you attach it in cfmail??
 
  jl
 
  On 7/8/06, Snake [EMAIL PROTECTED] wrote:
   Wrap it in cfsavecontent, then use cffile to save it.
   Then use cfmail to mail it.
  
   snake
  
   -Original Message-
   From: John Lucania [mailto:[EMAIL PROTECTED]
   Sent: 08 July 2006 17:54
   To: CF-Talk
   Subject: cfmail with attachment
  
   I need to run this on the Scheduled Task daily.
  
   bla...
  
 cfcontent type=application/vnd.ms-excel
   table
   tr
 themployee/th
 thfirstname/th
 thmiddlename/th
 thlastname/th
 thaddr1/th
 thaddr2/th
 thcity/th
 thstate/th
 thzip/th
 thhmphonenbr/th
 thdatehired/th
 thtermdate/th
 thdepartment/th
 thdepartmen2/th
 thjobcode/th
 thjobdescrip/th
 thempstatus/th
 themergconta/th
 themergphone/th
   /tr
   cfoutput query=GetSourceDemoInfo
 tr
 td#myemployee#/td
 td#myfirstname#/td
 td#mymiddlename#/td
 td#mylastname#/td
 td#myaddr1#/td
 td#myaddr2#/td
 td#mycity#/td
 td#mystate#/td
 td#myzip#/td
 td#myhmphonenbr#/td
 td#mydatehired#/td
 td#mytermdate#/td
 td#mydepartment#/td
 td#mydepartmen2#/td
 td#myjobcode#/td
 td#myjobdescrip#/td
 td#myempstatus#/td
 td#myemergconta#/td
 td#myemergphone#/td
 /tr
   /cfoutput
   /table
  
   bla...
  
   How do you save the result onto a directory as an Excel file?
   Also, how do you e-mail this file as an attachment?
  
   tia
  
   jl
  
  
  
  
 
 

 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245829
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Form to CFMAIL Sending Attachment Problem

2000-06-23 Thread KJis18

Ok what i am trying to do is send a "resume" document from a file field in a 
form, to the next page which will process it as a MIMEATTACH in the CFMAIL 
Tag.  For some reason, it does it correctly, but it does not show the right 
file attached, all it shows is a .tmp file.

Can someone help me?

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfmail File Attachment

2000-04-28 Thread Gregory Weiss

Yes,

This is true.  Whenever an attachment is called into an email, a temporary
file is created that is your attachment, and that file is then attached to
your outgoing email.  Thus, the specific call "C:\'Anything'" won't work.  I
use inFusion Mail Server, so I don't know exactly how the MIMEATTACH
attribute works (Ie:  What you should do to rectify your problem), but now
you have some more information with which to come up with a solution.

Hope this helps.

Greg

-Original Message-
From: david [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 27, 2000 9:51 AM
To: [EMAIL PROTECTED]
Subject: cfmail File Attachment


I created a simple email form which includes an INPUT NAME="Attachment"
TYPE="file" size="30".  When I submit the form I receive an error stating:

MIMEATTACH

  An invalid file name (C:\test.txt) was specified in the MIMEATTACH
attribute. Please verify that this file exists and that the ColdFusion
service has the privileges required to access it.


My host tech support states that file attachments must be temporarily
located on the server to send via an email attachment.


Is this true?  Does someone have experience with email MIMEATTACH?



david




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



cfmail File Attachment

2000-04-27 Thread david

I created a simple email form which includes an INPUT NAME="Attachment"
TYPE="file" size="30".  When I submit the form I receive an error stating:

MIMEATTACH

  An invalid file name (C:\test.txt) was specified in the MIMEATTACH
attribute. Please verify that this file exists and that the ColdFusion
service has the privileges required to access it.


My host tech support states that file attachments must be temporarily
located on the server to send via an email attachment.


Is this true?  Does someone have experience with email MIMEATTACH?



david



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.