Attaching Excel File Using ObjMail
I am using the following code to attach an excel file to email.. but a funny thing happens, the excel file comes in with no data, and the uploaded file DOES have data... is there a filesize limit using objMail.AttachFile ??
Set objMail = CreateObject("CDONTS.NewMail")
objMail.From = "sales@???.com"
Objmail.BodyFormat = 0
ObjMail.MailFormat = 0
objMail.To = email
objMail.Subject = "File attached"
objMail.AttachFile Server.MapPath("/download/file.xls")
objMail.Body= mbody
objMail.Send
'response.write("Mail send")
Set objMail = Nothing ....
View Replies
ADVERTISEMENT
I am using the following code to attach an excel file to email.. but a funny thing happens, the excel file comes in with no data, and the uploaded file DOES have data.. Code:
View Replies
View Related
I am using ASP 3.0 for sending emails through my website. It is correctly working and I also successfully attached server reside files via email attachment. I wish to send files from client's computer. Such as if I used input type "file" then I can get the file name with its path at client side but how can I tell the script to deal this path as client side path??? As I have used Server.MapPath but as it is work-full for server reside files. If user’s input file name is "c:documentmyfile.txt" then how can I work with it as my script will treat it as web server hard drive path.
My script can attach files but I do not know how can understand client side path.
View Replies
View Related
I am using Server.CreateObject("Scripting.FileSystemObject") to create a CSV file.
'create file
Set fs=Server.CreateObject("Scripting.FileSystemObject")
if fs.FileExists(server.MapPath("/temp/data.csv")) then
set myfile = fs.GetFile(server.MapPath("/temp/data.csv"))
myfile.delete
set myfile = nothing
end if
The CSV file is then attached to an email and sent.
Code:....
View Replies
View Related
My form has 20 e-mail variable... and i would like to do something like that:
objMail.To = request.form("one", "two", "three")
and so on...to send to everyone that need to receive the mail. (there´s a checkbox in the form
View Replies
View Related
I have been reading quite a bit on how to do the objMail.AttachFile object, and no one can seem to get to it work properly. I have seen many variations such as:
objMail.AttachFile = (C:MyPathMyFile)
objMail.AttachFile = ("C:MyPathMyFile")
objMail.AttachFile = "C:MyPathMyFile"
objMail.AttachFile(C:MyPathMyFile)
objMail.AttachFile( Server.MapPath(<directory>) & arrFileList(intIndex)
I havent seen anyone report that they got it to work. I am using enctype="multipart/form-data" on my original web form, specifying the input type="file", declaring the attached file variable on my asp page, and doing request.form to gather the appropriate value, but nothing works.
Other forum users have said that it does not like virtual paths, but rather hard-coded paths, for some reason. Does anyone have some good code that works?
View Replies
View Related
I'm running IIS 6.0 with Exchange 2003. One web site that is hosting is trying to use the new CDO method of sending e-mail.
SMTP Service is working fine for Exchange, but for web sites on the same box using code below generates:
CDO.Message.1 error '80070005'
Access is denied.
/test.asp, line 15
Site: http://www.ytr.com/test.asp
Code: ....
View Replies
View Related
I need to attach a file to a form and after i hit the attach button i need to diplay another button saying view attachment in the same form and want the browse and attach buttons to disappear.
View Replies
View Related
I would like mu users to be able to attach files using an interface deveolped in ASP. The files should then be saved in a database. How do I go about it?
View Replies
View Related
I am trying to send email with Jmail component i am attaching a picture with it and its not working and giving me an error which is as follows
jmail.SMTPMail error '8000ffff' Cannot open file C:InetPubDevSecureBelord
hino_small.jpg ....
View Replies
View Related
I am building a simple incident recording system using ASP.
The form has Name, email address, telno, incident description and records the data to an access db and send an email to the user with an incident ticket number.
The client has asked for an extra feature to be able to attach documents such as Word documents.
Has anyone got a sample script where on the form the user clicks a button where he/she can browse for the file to be attached and ASPEmail can than send the mail with attachment.
View Replies
View Related
It works if the file in on the server side, how to use the component (DSOleFile) with the file on the client side? Also how can I calculate the width of the file. (Page set up - Landscape or porrait). Code:
View Replies
View Related
I've got a problem attaching the Script Debugger to ASP pages under IIS6. Set up everything following IIS6 documentation: turned on ASP debug in IIS Manager; edited
permissions for Machine Debug Manager in the DCOM configuration, giving Launch and Activate permissions to Network Service (which is the account for the corresponding process pool).
IIS is in WP isolation mode. ASP is activated. Sending detailed error info to the browser is activated and works fine. No errors in event log about DCOM app attach permission denials.
View Replies
View Related
I want to Convert Excel Files to CSV files using ASP code CanAny body help me out in this.
View Replies
View Related
The title looks a bit odd, but it is what I really need
I have different users, which I get the information from them in an ASP page, the data is stored in a SQL database, one of these users is authorized to check and close the data entry.
Once the data entry is closed, an ‘Excel’ file should be generated according the entered data and be placed in a directory for use of other users.
My problem is how I can generate the mentioned ‘Excel’ file by clicking a button in an ASP page and transfer the recorded data in it.
View Replies
View Related
I have to add a feature, on click of button file open as dialog box will open and user can attach a excel file. Then we can able to validate, actually file attached or not, it is excel file or not etc.. if everything is ok app will will do further processing on the file.. Can anybody suggest me the easy way out without licencing issues.. Since vbscript and jscript is used any fee tool available...I tried to do it through MSComDlg.CommonDialog but it is a licenced version. Also I tried to do it through <input type=file>
but here one text box and browse button gets added..
View Replies
View Related
I am trying to create an excel file consisting of data from a SQL database using asp. I dont want the file to open up in the browser. I want the file to be opened in Microsoft excel. I have seen similar questions out here but no answers.
View Replies
View Related
One of the pages of my application opens an Excel 2000 workbook in a
new window using Javascript. The workbook is read only and I use a
window.open command to open the workbook. On the workbook's
BeforeClose event I have a code to avoid the 'Save' dialog: Me.Saved =
True
If I open the page locally, change some content and close the
workbook, the 'Save' dialog does not appear, as expected. As soon as I
open the workbook on the web, the 'Save' dialog still appears when I
close the window. I need to allow my users to change the contents of
the workbook but they cannot save the workbook. Is my approach wrong?
How can I avoid the 'Save' dialog?
View Replies
View Related
Can anyone help with this? Here is the code I am using. The problem
is, where it checks if a file exists, it always goes to else. Even if
the file is there, it won't open the file, goes straight to else part
of statement.
<%
If Session("strLogID") = "" Then
Response.Redirect("http://website/pages/login.asp")
Else
strfile = Request.Form("month") & Request.Form("day") & " Misses" &
".xls"
Set fs = Server.CreateObject("Scripting.FileSystemObject")
If fs.FileExists("http://website/webreports/Misses/" & strfile) THEN
Response.Redirect("http://website/webreports/Misses/" & strfile)
Else
Response.Redirect("http://website/pages/missedreport.asp")
End If
End If
%>
View Replies
View Related
I am creating a webpage and have a form where a visitor will choose a
day, month, and year. I want to pass the data from the form into an
asp page which will process it and put it into a string and open the
excel file requested. The excel file to open will depend on the day,
month, and year chosen in the form.
View Replies
View Related
I have a asp page which will get the data from multiple tables (with
functions and procedures)and display data in HTML tables <TABLE> on ASP
page.Is there any way we can create a excel file from the output of this ASP
file.I know how to export if this information on ASP page is coming from single
query from a database table.
View Replies
View Related
Is there a way to insure the user can't save the excel file that has been opened?
I have a link that goes to XLS files for users but I don't want to users to be able to save the XLS files to there local drive.
View Replies
View Related
I need to give users the option to enter a zip-code in a html form, and then search through an excel-file for that zip-code. If any entries are found, then I have to output these as html.
How should i start? And what if several users tries to search the excel-file at once?
Basically I need to search the excel-file as I would search a db.
I've done a few searches on google, but haven't really found any relevant info.
View Replies
View Related
How to import a text file into Excel file using macro? Can this process run on the form menu button? I have attached a text file for your reference.
Please give me some ideas of doing it
View Replies
View Related
I' m trying to import an Excel file in a SQLServer db. If I specify the spreadsheet name it works correctly. Now I'd like to import the spreadsheet without specify its name. Is there a way to retrieve the spreadsheet names of my Excel file in ASP?
View Replies
View Related
After a user make the search, it returns 100 rows of record on the display page. I want to give an option for the user to save the records as Excel spreadsheet. Like a small icon on the corner, it prompts to save if click.Can anyone teach me how to do it? or have a simple tutorial or code that i can see?
View Replies
View Related
I'm trying to create a excel file from set of data. actually I'm using ASP + JScript.
I'm glad to hear your oppinion.
View Replies
View Related
With response.contenttype = "application/vnd.ms-excel", I can easily export my data to Excel which is embeded and shown within a browser. If I'm going to save the Excel file through ASP programming, which method can I use? I need to save the data to Excel file with dynamic name (the file name should contain key values and appended with system datetime).
View Replies
View Related
I have a SQL query to generate the report for me in SQL Query Analyzer. I would like to create an ASP page that has a link, and when people click on that link, it will prompt a download message (open or save) in Excel format. Is there any codes can do this?
View Replies
View Related
I need to write a program that can create an excel file and copy all the data obtains from a database to the excel file. Then save and close the excel file or do all of the above in the backgroud. if you have written similar program or know where I can find the sample code for this feature.
View Replies
View Related
How do i export content of an ASP page to multiple worksheets of an excel workbook. For example i'm having an asp page which contains a combo box. The user selects a center from the combo box and results are displayed. On clicking 'Export to Excel' i'm exporting the page to excel.
If the user is going to select 'All' option from the combo box, results for all centers are displayed. Now while clicking 'Export to Excel', the content of each center should be exported to a single worksheet. If 10 centers are there, then the workbook should contain 10 worksheets (sheet1, sheet 2... sheet10).
View Replies
View Related
If there are any tutorials out there or websites that can explain more about this? How to get data from an excel file(or any other file like a .txt) and inserting them into a database using asp? can this be done in asp?
View Replies
View Related
I do not get an error, but I also do not get any data in the excel file. I
know it is connecting to the db Code:
View Replies
View Related
