I have a 2000 server running IIS 5. I need to send approximately 10000 emails to recipients from an excel spreadsheet with a small word document. These are requested emails, no spamming. I don't have a clue as to where/how to start this.
View RepliesWe have an application where the user fills out many screens and when
they are done, we are supposed to display the text they entered in a
word or excel format. That is fairly easily accomplished by changing
the content type in the response object.
On one of the screens where they enter data, they also have the
ability to upload a word document containing additional information.
This is also not a problem, and is working fine.
Now they have decided that when we create the document with all of the
text fields in it, they want to embed the word document that they
uploaded. Is this possible? I have been trying to find a way to do
this and so far haven't come up with anything.
I have an Excel Template that is filled out in certain senarios. What I want to be able to do is access this existing Excel Template through a webpage, enter nessisary data into the template, and then e-mail these changes to certain people. The original Excel template needs to stay Unfilled out and unmodified once the process is complete. If saving a different copy to e-mail is nessisary that is ok. I have Created the Excel object on the server to be filled with database info from a query, but I'm not sure how to open an current excel document and then email that document onces it is filled out..
View Replies View RelatedI have an ASP script that send mail to recipients:
inside it have:
1. link to a document stored on my server
2. same document as attachment
Problem:
sometimes the when you try to open the attachment it opens as gebberesh, and word ask you to choose encoding (offcourse no encoding fits).
In the same time when you try to open this document via link to a server it opens fine....
I have my excel spreadsheet generating just fine. What I'm trying to do is format each cell to something other than "general" I've figure out how to format to currency:
<td>$<%=variable%></td>
I really need to format to "text" though. Anyone have a good link to a chart that explains how to format to all of the different possibilites, or just how to format to text?
I'm successfully using Response.ContentType = "application/vnd.ms-excel" to generate an Excel spreadsheet from an asp page and a SQL Server database.One of the columns contains data that is a long number (13 characters eg. 1122334444566).The spreadsheet does not display the number correctly because the column is formatted as 'General' so it displays 1.12233E+12.To correct this in Excel I simply change the column type to number. How do I get around this in asp.
I know I could use fso to create the spreadsheet on the server using a template, but I prefer to do it on the client side so that I don't accumulate a whole lot of xls files on the server.
What is the syntax to connect to an excel spreadsheet as well displaying contents of a column.
View Replies View RelatedI have a report that the user can view either on a page with HTML or they can open it in Excel.
I am attempting to change the content type with this statement:
response.contentType = "application/vnd.ms-excel"
But it appears that when I do this I lose all my request variables and my recordset is null.
I am creating a website in which users will be able to query an sql database by several different criteria (i.e.- name, department,supplier, part#, date). What will return to the user will be a webpage with the column headings that they selected in their search criteria (i.e.- name, supplier, part#) and below those column headings, a list of the results.
I want the user to be able to print this report or export it to an excel file, this is the part that is tripping me up.Any ideas about this? Am I going about it all wrong?
How to using asp script update data in Excel Spreadsheet with style (ie, Bold, Font Size ..) ? Is it possible to do that ?
View Replies View RelatedI'm using the Excel application object to create a
spreadsheet from a recordset. Everything seems to work
fine except any date fields are not displaying properly.
For example 4/18/2004 is displaying as 38095 in the
spreadsheet.
I loop through the recordset to display each row. The
line that actually writes out the field is:
objSpreadsheet.Cells(iRow, iCol).Value = objField.Value
Any suggestions?
I am trying to import an excel spread sheet, my first step is to be able to see the spreadsheet on the webpage, Code:
View Replies View RelatedWhat would be involved with having an Excel spreadsheet displayed in an ASP page? The additional problem is that the file name changes on a monthly basis. For example, this month's file name is 'Feb 2005.xls'.
View Replies View RelatedI have asp project where large volume of data entry would be done. I am
trying to find out if there is any tool that can allow me to build asp
application where the forms would be like excel spreadsheet.
I'm exporting tables to Excel, but they seem to format with an extra row between every record. The table is output in HTML on one line, so it doesn't seem to be a white space problem.
View Replies View RelatedHow to using one excel template to insert data into another excel spreadsheet by using asp programming ?
View Replies View RelatedI've been reading through all related Excel posts now for about an hour as well as Googling for my answer and I'm getting even more cornfuzed as I go. I have an Existing Excel Spreadsheet, I need to populate certain fields of the form with values from a Database.
I have no problems connecting to my database and pulling up the data, but I have no idea where to begin with opening my existing spreadsheet, then telling it which worksheet to use and then how to populate the fields I need.
I'm not looking for an entire code handout, this is just something that I haven't attempted before in ASP. If someone could just give a quick example of first opening the existing spreadsheet, selecting the correct worksheet and populating 1 field, I think I can figure everything else out from there.
I want 2 create a survey Web Form that people can fill in. I then want the data entered to be saved to an Excel spreadsheet located on a server.
Can .ASP handle this kind of task? and if so does anyone know the code required to perform this function?
The data entered will be RAW and the .ASP (or whatever required programming) will need 2 process and convert the data into the spreadsheet.
Also, would it be possible to run this from a stand alone machine so that the web form, .ASP and spreadsheet are all contained on the machine and have no outside influences?
I've inherited this asp page. It builds an Excel spreadsheet, but it's not putting the date in the spreadsheet and I don't know why. here is the code (see bold-red line): ...
View Replies View RelatedI want to do a Ms Word document in a ASP page. I can do it, With the code lines:
/////
Response.ContentType = "application/msword"
Response.AddHeader "content-disposition", "inline; filename=OrderFax.doc"
////
With these lines all document content show like a Word document.
But i can not change the MARGINS of this Word document.And Default
left/right margins are very bigs.
I try it, change the <body> attributes and with styles, but this don't work,
the margins are always the same.
How can i modify the margins of word document? I should do this with another method?
Can I modify PC client settings to change the defaults margins of word document create througt the web?
I'm currently working on an application that has to open word documents (word forms) and read and write data from/to it. But, unfortunately, the web server hasn't Word installed (my ISP...). Is there any other way to do that?
I'm currently investigating about working with rtf documents, but the syntax is turning me crazy!!! Any idea/dll/other way to do that?
I've been looking (unsuccessfully) for a tutorial on creating Word documents from ASP. I know it can be done and have been able to find some references to various aspects of this, but nothing that spells out the process from beginning to end.
What I'm trying to accomplish is being able to generate a paper document using some information that is contained in an Access database. I have a ASP script that will generate the same info on the screen, but nothing that will put it on paper in a clean, professional format.
I am creating a word document from an asp page. I have no problems
actaully creating the document and creating some tables that have data
in them. I am using Response.ContentType = "application/vnd.ms-word"
to create the actual document. My problem is that I want to place a
picture (which resides on the server) into the word document as well.
However all I seem to get is the place for the image but a picture of
an "x" meaning that the picture is missing.
Using Input in HTML i am allowing user upload the
document. When they click submit i am saving in Server.
They can upload same document any time. Here is my problem
each time when they upload document it is saved in server
But when they open in browser new updated document is not
shown only old document is displayed.
I have link buttion i am assinging like this
http://myservername/sparktrial/SOW/sow-123.doc
the link is working they able to seek document but it not
showing latest document. Code:
if there is any way to transfer the data inside of a Microsoft Word (.doc) through asp into a database field?
View Replies View RelatedIf anyone has any suggestions on how I could get specific data from a word document into a Database please advise. I need this to work via our website.
Scenario: User uploads a word doc to our server. Then is presented with a button that reads "parse it".
I need to write something in asp that will open up the word doc and extract out specific data then simple insert it into a SQL db.
I know that using Word Automation inside an ASP page is no good idea.Anything I want to do in the current project is: open document, change some text, save and close document. Basically changing some variables, consting of a name embraced by special chars, to some value. As for example: change "[FirstName]" to "Michael".
Does anybody know whether there is a way for achieving this with basic "file input / output". Can I regard a Word document as some binary data, perform the replacement, and save the data, without destroying Word's internal structure?
I want to open a word document in asp.(if possible with FSO)(I don't want to create a word with asp!)
View Replies View Relatedany way to modify text content of a word document through ASP?
View Replies View RelatedI am working on a application in ASP which has some data to be written to a Word document which can used as a template.I am having problems in creating an Object to open a word document.
View Replies View RelatedI wanted to know how to make a properly formated word document from asp. Can some one direct me to all the propertise of CreateObject("word.application").
View Replies View RelatedI am having a issue to read the word document and to print the content of the same document can any one please help me out in this case.
View Replies View RelatedI have a website which displays information from a database. I would like to add an option that when the user is pressing a button or link, a specific form as a WORD document will open on his desktop filled in specific places with data from the database. The original empty WORD doc is stored on the server.
View Replies View Related