>- see footer for list info -< I would first of all not hardcode the directory in enquiries_record.cfm but use ExpandPath() to generate it dynamically that way it will adjust much better to being moved from a local server to your hosting.
On Apr 12, 2005 1:40 PM, David Wyld <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > > > I have had a little difficulty getting an email scheduled to send a csv > attachment. > I have done the following it works OK on my application server but fails on > host > any suggestions? > 1. set up a MIME attachemnt Type= application, extension = .csv. > 2.Set up the code on two .cfm files > <cfschedule action="update" task="dailyemail" operation="HTTPRequest" > url="http://www.customer.co.uk/enquiries_record.cfm"; startdate="04/04/05" > starttime="11:00 PM" interval="daily"> > The enquiries_record.cfm code is: > </style> > </head> > <cfset f_dir = "d:\wwwroot\................\reports\" > <cfset f_name = "#dateformat(now(),'ddmmyy')#.csv"> > <body><span class="style1"> > <cfmail TO="moi<ST1:PERSoNNAME style="BACKGROUND-IMAGE: > url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x; BACKGROUND-: left > bottom"@site.com</ST1:PERSoNNAME > FROM="[EMAIL PROTECTED]" > SUBJECT="Daily Record of all enquiries"> > <cfmailparam file="#f_dir##f_name#" type= "application/csv"> > <!...text....> > </cfmail> </span> > </body> > </html> > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
