Create Automated MailMerge Letter
how to create automated MailMerge which creates a form letter using SQL connection using ASP?
View Replies
ADVERTISEMENT
MailMerge
Does anyone know any sites that would offer already prebuild application that would generate letter form using sql string?
View Replies View RelatedMailmerge In ASP
I have an ASP program that automatically sends text by email to customers. I would now like to improve it so that I can collect all the email text in a mail merge document and have the possibility of it by post. What's the best solution to mailmerge such info in ASP?
View Replies View RelatedHow To Automate MailMerge Into ASP
Does anyone know how to autome word mailmerge to create Letter forms using ASP?
View Replies View RelatedUsing Access To Store A Word Document And Use It For Mailmerge
I am presently saving a word document to an access table in a OLE Object field. I retrieve the document and display it fine.
I would like to retrieve information from one of the other tables and merge the two together. And then display the new word document. Inother words do a mail merge or replace.
Automated Changes
I want to develop a little application for my intranet. There is a person who is on-call, and this person changes once a week. Rather than having the person remember to change him/herself in the system so that they are reflected as the new "person who is on-call" for their week.
Instead, I would like to automate the process by developing an application that would read a series of ID's (that reflect the people who are in the database) who will sequentially be "on-call".
My question is, how can I (through ASP/VBscript on an IIS 5.0/Win2K Platform) automatically run a set of ASP without invoking the page (so that it can automatically change the person who is "on call" every weekend.)?
Automated Email
I need to send an automated email each day (Member expiration notices). The data sits in an SQL Server but SQL Mail is not available.
Building an .asp page that makes this happen isn't a problem, but that page would have to be loaded each day for the process to run....
Automated Emails
I need to send a set of Emails from my application (reminders) each month
1st. Is there anyway in ASP scripts to trigger an event to run
automatically? I have no dedicated server, so no DLLs or Scheduler scripts
can be used. Also adding the trigger script in the application object may
not send emails in time, as we have not enough visitors to that application.
Is there any way other than 'Clicking a Send button'
Get UNC From Drive Letter
1. The file is on a map drive, which is mapped to a folder
on the same server. Example. The user's folder 'John'.
2. I am able to get the file information
("E:PhotosImage1.jpg") and can copy the file to the
folder. ONCE I KNOW THE UNC ("headoffice-
dellsystPhotosImage1.jpg" file to copy)
I would like to be able to get the UNC from the user's
system, by submitting the drive letter to a function.
This script is for an Intranet and should be in ASP or
JavaScript.
..
Letter At Certain Position
After I read in a value from a table i need to read in the last letter of the value and check if it has an "s" as its last letter, so that i can display either ' or 's.
Does anyone know how code to view the last letter of the value or move the variable into javascript so that I can manipulate it from their?
Automated Code
How do I create an app that will send out emails automatically based on some criteria? Is it possible? I have some projects in a db and I would like to send emails at the end of the day to certain people in the project if that project has been update.
These emails would be sent some time between the end of a business day and beginning of another but only if the project has been updated that day. That is if someone updates project1 today, I need to send an email out sometime between today and tomorrow only for project1 but not for project2, project3, etc. I would like this to be some automated app.
Update: I have created a report in Crystal Reports that contains the reports I need to send. If anyone can direct me somewhere I can find out how to do this in either plain old ASP, ASP.Net by itself of using CR it would be great.
Like Statement First Letter
i want to query a fields first letter.how can i do this?Code:
strsql = "SELECT * FROM COORD WHERE First='" & Request.Form("UserName") & "' AND last LIKE '%" & right(last,1) & "%' and active ='" & Request.Form("Password") & "'"
I want the search last by only the first letter of there name.
First Letter To Uppercase
i need to convert the first letter of a veriable to uppercase (the veriable is loaded and the applied LCase() ).
View Replies View RelatedCapitalize Letter
im building an ecommerce site. I asked the client to populate the database i built with all 3000 of their products. They have done this, but put all the data in in CAPITALS. Ive tried 'capitalising' (first letter of each word is a capital) the words in css, but that doesnt work because the letters are all in caps (it would work if they were in lower case).
Has anyone a function written in asp (jscript) to achieve this? Or should I try doing this in sql if this is possible?
First Letter Is Uppercase
I want to take a value that users type into a field (actually 2 fields--first and last name) and convert the first letter to Upper Case. I thought I could use UCase, but it seems to only work for an entire string.
View Replies View RelatedAutomated Translation
i want automated translation of Classic ASP to ASP.Net?Any software out there to do this?
View Replies View RelatedCapitalize First Letter
We have an ASP VBScript email autoreply. I'd like to make it extra squeaky-clean and have it auto-capitalize the user's first name if they did not. I.e.
"Dear bob, your order has been placed."
to
"Dear Bob, your order has been placed."
I realize that probably the pro way would be to normalize it in the DB when they first sign up.. but this is not necessary, I just need some kinda left-trim-uppercase-codeamabob.
Automated File Transfer
My team would like to use an ASP script to have an automatic transfer of files to our live server happen each evening at a predetermined time. I was looking on the web for a script but all I could find is user driven upload scripts.
Is there anything out there that will facilitate automatic uploads of several folders and files via ASP scripts?
Asp Sort Records By First Letter
I am using asp and access database on my page Up untill now I have just been listing all catagories from the database on one page, now the list has become huge.
I would like to have a page with an alphabetical list of links A, B, C etc and then just display the catagory records beginning with A etc depending on user input.
Selecting DB Results Where First Letter = ?
What query would I have to use to select entries from a database where there first letter is a letter of the alphabet? ie. Select all entries starting with an A etc.
View Replies View RelatedI Have Records Where I Need To Replace One Letter With Another.
I have records where I need to replace one letter with another. Can I modify this highlighting code to do that?
What I need to do is to update my table of database where a column has to replace one letter with another. WHat I have is the "insert into" statement where I duplicated the table (not shown below) Code:
Automated Running Of Page
I am design an web application that requires information mation to be created from tables once a day, once this information has been created it is stored temporarily in another table until the folowing day. The problem is that to creat this information a seperate .asp page has to run.
I would like this page to run early in the morning when no one is in the building and accessing the servers. I have tried using windows scheduler... this works but still needs a user to press ok on the internet security password screen we have set up. Is there any other way to get the page to run without using the browser, or to change the page into a dfferent format??
First Letter In Upper Case
How to make first letter of word in upper case?
i.e. hello should return Hello
Is there any inbuilt function?
Chopping Off The First Letter Of A String
Basically i have a string with a value that either starts with U or N.
If the string starts with a U, I would like to chop that U off but leave the rest of the string. If it starts with an N, then i would need to keep the N on the string. For example,
strUID = U369373
If strUID = 'starts with a U' Then
'Chop off the U to create 369373 instead of U369373'
End If
Should be a fairly easy logical statement, but i just forgot the variables to do that.
Automated Password Recovery
Ok, this is a true testament to the fact that "If you work more on the design process, you spend less time in the development process."
Anyways, I am looking for an ASP based solution (ideas, I like writing the code!) for the following situation. I have read multiple articles saying that "You should never store passwords unencrypted in a database", in as much what I do is store the passwords in one way Hash MD5 encryption (can't decrypt it)
So after working for 5 hours on a getting a nice automated system that emails the user their username and password depending on the username/email address they supplied, I noticed in the email that I sent myself, that the password was a MD5 hash.
Great; all that for nothing.
When I've lost my passwords, I've seen "reactivate your account" links in emails where the user clicks on a HUGE links (the querystring is the big part) and it takes them to a page where they can do something in order to have some random password override their old password, which they can then of course log back into their control panel and change it to something more memorable (I wuv my control I made)
Anyways, you guys got an ideas how they do this, or by what method I should use to get the safest and most secure results.
I want to make sure that through both information/password changes (should I automate it and let user change PW or should they always request that change from me) and with automated pw recovery / account reactivation, that I never accidentally lock them permanently out of their accounts.
Automated Date Check
I have a booking system that allows a user to book a room for a set time period of a day, what i want to do is on the day that the room is booked for is send an email to the person that booked it.
I can already send an email thats not an issue i have all the other information other than the ability for the site to on its own with no user input send an email so when it comes to the day they have the room booked for at 8.30 am i want the site to check all bookings and email the person responsible, make sense?
Automated Mail Formatting
How do I put a carriage return in the body of an email sent from the asp? Also I am
getting an error with this test code:
sendFrom="LoanerPool"
SendTo=Request.Form("NTechOut")
strSubject="Automated Checkout Response (do not reply)"
strBody="This is an automated response from the loanerpool."
set MailObject = Server.CreateObject("CDO.Message")
MailObject.From = sendFrom
MailObject.To = sendTo
MailObject.Subject = strSubject
MailObject.HTMLBody = strBody
MailObject.Send
The error is:
Error: The "SendUsing" configuration value is invalid.
Protect Automated Registration
I have one registration form with "submit" button. I don't know how to make protection from automatic submit (with picture and security code)?
View Replies View RelatedAutomated Registration Attack
when we register a email account, it hv a picture that got few words inside, n ask us to write the word to prevent automated registration attack. wat is this techinque called ? n anybody got this sample code ?
View Replies View RelatedAutomated Mail Delivery
i am sending automated mails once a person registers to the site using CDONTS, but this mail does not reach persons with msn or rediff maild's , i have tried using CDOSYS, even this is of no help.
View Replies View RelatedLetter Be Is Inserted Into Numbers
when I ourput data from Access, numbers bigger than 999 are shown with letter "B" inserted into the 4th position left to the coma. (in my w2k regional settings I have the decimal dot separator set to "." and digit group separater set to nothing. In Access the number are shown with "." as decimal separator, but for some reason ASP used "," instead)
Say, 3000,00 is shown as 3B 000,00 Why and how do I sort this out?
Automated Form Submission
most websites make use of CAPTCHA to prevent automated Form submission. give me examples of how automated Form submission can be achieved? It's not that I intend to do some nefarious activities; rather I don't understand how can automated Form submission be done other than the website developer coding it (for e.g. using JavaScript to automatically post a Form, say, after 2 minutes).
View Replies View RelatedAutomated Call Of Script
Is there any way I can call an ASP script (script.asp) on a regular basis? There are several catches:
I have no access to the server setup
I might have access to the global.asa (but might not)
I have no SQL Server
If this is one of those things that are just impossible, is there a service out there that will call a URL on a regular basis for low cost? It's not a very intense operation, basically it is called once a day.