How Send The Letter
Hello all:
In order to set up an multi-receiver email program with ASP/AccessDB,
I downloaded “Beginners ASP mailing list program” “newsletter.zip”
After unzipped it, it contains 11 files. I put them all in the wwwroot of IIS.
I have made the address database “newsletter.mdb” successfully. The next
step is to send letter.
First using “newslettercreat.htm” to write a letter and then press “submit”.
After submitting, it prompt a IE page with address “newlettercreat.asp”, but
says: “The page cannot be displayed” and with following
information:
---------------------------------------------------
Technical Information (for support personnel)
Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid class string
/newslettercreate.asp, line 22So, the letter can not be sent.
What is the ERROR of “Server object, ASP 0177 (0x800401F3) Invalid class string” ?
My OS is winXP pro, email program is Outlook Express. Who could help l me solve
this problem? Thanks!
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Letter By Letter Search Through A Table
ok here is what i want.. imagine a search box, just an empty text box that allows the user to type things into it... there will be a simple table from the database behind it, here is the typical structure of a record <Country>Poland <Price1>60 <Price2>85 <Price3>95 in this table there will be say a 1000 of these records... my user is going to have to quickly search through these records while on the phone to a customer, and quote one of the relevant prices associated with that country what i would like is this most convenient system.. as the user types in the letter 'P' just below all the records with countries that begin with 'P' are displayed (with a scroll down arrow if needed)..as well as the 3 relevant prices with that record if they then type an 'O' into the box (which will now hold 'Po') all the records with countries beginin with 'Po' will be displayed (eg Poland) if they delete the 'o'. once again the displayed records below the box will return to just the countries begginin with 'p' all that is needed is for the records to be displayed, thats it.. but the adding and deleting of the letters within the text search box will need to instantly manipulate this list.. i have posted on other forums, and have been told this can be acheived in access, is it hard?
View Replies !
View Related
Letter Help
hi, Im creating a letter. It is based on a query. I have some details that I'd like to display , one on it's own line. I cant print them out now, but they dont all fall on their own separate lines. How should I do that? If I put a carriage control at the end of each detail line, will it know to print each of the fields on its own line? I need advice . I tried doing a subreport -type letter, but it looks weird! thanks!
View Replies !
View Related
Starting Letter
I want a criteris in access to get the records having field 2 starting with "num". Num is example. I want to do withdifferent letters. number numbiur numg numds the first three letter should be num in this example. i want for different words i.e, i need to enter the paramter message box.
View Replies !
View Related
Letter And Query
Hi, I'm fairly new to Access. I have few questions. How to set up database so it searches through my table, finds the name and inputs it into letter in a space I want? Where does this letter suppose to be located in the file? Thank you IOI
View Replies !
View Related
Does Not Start With A Letter
Hi All:given a table with, let's say, Job Numbers that start with a letter (such as RES2345) or just plain numbers (such as 253180001 or 9817) how can I set the criteria in the query to just give me jobs that start with a number?I first trimmed the field to eliminate blank characters and then I used the Not Like "A - Z" but it still gives me jobs with letters at the beginning of the name.thanks for all your help in advance. :D
View Replies !
View Related
Display Only One Letter
I am trying to get the firstname to only display the first letter in a report. I have put this format in the control source =Left([firstname],1) When I run the report I get error in the firstname field. Any suggestion. Thanks
View Replies !
View Related
Edit A Report Letter
i'm trying to work with this database. i want to know how to change a few things we have a command button that generates a letter i need to edit that letter as it contains names and numbers no longer in the office is there a way i could find that letter i tried to have sent to a .rtf file which i could modify, but that's tolerable for a dozen of recipient not 2 to 3 hundreds thanks
View Replies !
View Related
Generating A Letter From MS Access
I need to generate a pre-formatted letter from within MS Access, where the name, address and other information will be pulled from the current record on an Access Form. Basically it is like a welcome letter I could send to any new client I enter into the data base. Since I am doing one letter at the time, mail merge in MS Word is not an option What would be the easiest way to do this? Thanks
View Replies !
View Related
Letter Storage & Retrieval
I am not sure whether this is a problem with MS Access, Visual Basic or Windows. I have taken over supporting & developing an MS Access 2000 DB for a small charity & am not an Access expert or a programmer. The Application includes processing to create, amend & store retrieve standard letters based on a Word document called MyMerge.doc. The operating systems is Windows XP for the PCs with a MS Server 2003. Each letter is allocated a number ‘CallID’ which is used to retrieve the letters later. The letter text is in MessageC. The VB code to store the letters (Save As) is Dim strTest As String, db As DAO.Database Dim td As DAO.TableDef Set db = CurrentDb For Each td In db.TableDefs If Len(td.Connect) > 0 Then MessageE = Mid(Left(td.Connect, InStrRev(td.Connect, "") - 1), 11) GoTo jumpout Next jumpout: MessageC = "%fa" & MessageE & "Db Letters" & MessageC & " " & (CStr(Forms!Contacts![PostalCode])) & " " & Trim(DLookup("[TitleType]", "Title Types", "[TitleTypeID] = Forms!Contacts![TitleTypeID]") & " " & Forms!Contacts![FirstName] & " " & Forms!Contacts![LastName]) objWord.Application.Activate SendKeys MessageC The VB code to retrieve the letters is Dim MessageE As String, db As DAO.Database Dim td As DAO.TableDef Set db = CurrentDb For Each td In db.TableDefs If Len(td.Connect) > 0 Then MessageE = Mid(Left(td.Connect, InStrRev(td.Connect, "") - 1), 11) GoTo jumpout Next jumpout: Dim WordApp As Word.Application Set WordApp = CreateObject("Word.Application") WordApp.Visible = True WordApp.Application.Activate MessageE = "%fo" & MessageE & "Db Letters*" & CallID & "*.doc" SendKeys MessageE Set WordApp = Nothing GoTo Exit_Command53_Click The success rate varies from PC to PC and user to user. It will work with one letter and not the next. It is very difficult to identify a pattern. When the Save As does not offer the expected name & path, the Application (or operating system?) offers to save ‘MyMerge’ to the user’s My Documents folder. In that case I tell the users to correct the path themselves and save the document under the CallID. Theoretically, retrieval should work since this uses the CallID and wild cards. Sometimes it does but often it will instead retrieve a document in the user’s My Documents folder. If it does go to the right folder, you sometimes have to replace the last wild card with ‘.doc’. I have tried replacing the last wild card in the VB code with ‘.doc’ but this does not work! Finally, I alone get the message ‘Save failed due to out of memory or disk space’, neither of which is true. This makes it very difficult to continue investigating the problem. If I use a copy of the DB on my hard drive rather than the network I can save but not retrieve.
View Replies !
View Related
Form Letter Ideas
I want to pick everyone's brain on this one, because I'm not sure what I want to do can be done very easily. I have a database that tracks client information for insurance policies. I'm going to be giving it to other agents, many who are very computer illiterate. One of the requested functions is for them to be able to create form letters from the database. So, I'd like some ideas on how to do that. Ideally, I'd like for there to be a form that someone could load some letter templates, but also tweak them or even create new ones that can be saved. It would also need to have "merge fields" much like you would in Microsoft Word. Basically since every agent will want to have their own letters, it needs to be easily editable. Is there an easy way for a computer illiterate person to just select "interest letter," change some wording, and have it merge into a report? Or, is there an easy way for someone to get access to the merge fields if they were to do a Word mail merge? I don't really want people trying to find the right tables/queries amidst all the different tables in the database. Or, throw out some other ideas. I'm open for most anything. Thanks in advance.
View Replies !
View Related
Query To Look At The 3rd Letter In A Field
Hi, anyone know if it possibe to create a field within a query that looks at a 3 letter number code in a field of a table named "employee master" to see if the last number is an "I" or not. So for example a number code in a field named "Department" is "KTI". I would like to display "indirect" in that field if it contains a "I" in the 3rd letter of the number. And display "direct" if the third letter is a "D" intstead, tried doing IF statements but not sure how to go about it, any help would be great.
View Replies !
View Related
Membership Renewal Letter.
Ok the database that i have contain all the details about customers including thier joining date. I want to make a query that will produce relevant information for use on a membership renewal letter, It should show only members due for renewal on 1st of may (there are 3 renewal dates per year. 1st jan , 1st may and 1st sept. I need to assume that the next renewal month of membership for those joining between those months will be the next renewal date. Example if you join in June your renewal date would be 1st september) Could you please explain how i could do this in easy to understand language as i am no expert with access. Thanks
View Replies !
View Related
First Letter Should Be A Capital, The Rest Not
Hi, I have a set of data and some are in capitals and some are not. This set of data is meant to be used for a mailing, and the home style of my company only allows the first letter to be a capital, the rest should be normal letters. Anyone have an idea how I can arrange this? Thanks in advance!
View Replies !
View Related
Need To Create A Form Letter....
I need to add a basic button on a form that would populate the current on-screen data in a form letter. The fields I have are name, address, city state zip and amount. I currently have the basic buttons on my form - Search, Next, Previous,Add, Delete Print Current Record. Thanks in advance for your assistance.
View Replies !
View Related
Adding Letter To Number
Hi, I have a database in which info is imported from a flatfile. In the database I have a query to select relevant info to appear on a report for invoicing. Now the imported info adds a number in a column for all rows. example: it adds 9600 to all invoices, based on the info that is imported. Now I want the import and export invoices to be separate, and the numbers to display 9600A and 9600B. Is there something I can add to the query in order to get this result? Thx, Lion85heart Reading this, I think it might be a bit unclear, so pls. ask any questions that you might have.
View Replies !
View Related
Printing A Letter From Access
Dear All: I have created a print command button on a form. When this button is pressed, It should print a Word document. I have composed this document in Word already. Any ideas on how to do this? Many thanks in advance, Dion
View Replies !
View Related
Printing A Letter From Access
Dear all: Code: Private Sub Command167_Click() On Error GoTo Err_Command167_Click Dim objWordApp As Object Dim objWordDoc As Object Set oApp = CreateObject("Word.Application") 'make word not show up to user objWordApp.Visible = False set objWordDoc = objWordApp.Documents.Open(C:Documents and SettingsUserDesktopEXPRESS DIPLOMA LETTER.doc) objWordDoc.PrintOut 'quits word objWordApp.Quit Set objWordDoc = Nothing Set objWordApp = Nothing Exit_Command167_Click: Exit Sub Err_Command167_Click: MsgBox Err.Description Resume Exit_Command167_Click End Sub I am trying to print a letter from access when a comand butting is pressed. It returns syntax error on this line:set objWordDoc = objWordApp.Documents.Open(C:Documents and SettingsUserDesktopEXPRESS DIPLOMA LETTER.doc) HELP!!! Many thanks, Dion
View Replies !
View Related
Add Write A Letter To Data Base
I am developing a membership data base from a MS Template. It aleady has the means to print member lists and invoices, but no letters. I would like to also have the capability of writing a letter to one or all of the members directly from the data base.
View Replies !
View Related
Query To Check First Letter Capital
Hi. I have a load of records, that some of the first letter of a field, are not capitals, otherwise they are ok. the are loads of them though, so would take too long to go through by hand, is there a query i can run, to check it and change it if not? Thanks Alex
View Replies !
View Related
Mail System, Checking If Letter Has Already Been Sent,
Hi, I've just started a new project where customer details will be inserted into a database ready to be mail merged onto labels. It'll be dealing with around 50 records per day so it will need to be automated. These records that we get may very well contain duplicates so im hoping to build a system that can check if a letter has been sent to that recipient already. For example, in one month there could be 60 records for the same recipent - wouldnt want to send 60 letters to them!! This is the process im hoping to build Person inputs data into a form - which goes into a table called ToBeSent | I need a way to check if the added record is already in table 'History' . If there is a record in the history table = dont send | If there are no matching records in the history table, send. I'm thinking of using the Name of the person or the post code or both if possible? to check if there are any matching records. My question is what would be the best way about doing this? Thanks
View Replies !
View Related
Query With Resulting Print Of Letter
I am assisting with the design of a db, where depending on two criteria, one of two letters needs to be printed. If one check box is positive, a letter is to be generated. If it is empty then a second checkbox will be checked, resulting in a different letter. I appreciate any assistance. :o
View Replies !
View Related
Letter + Auto Number From Surname
Hi i have to design a member database in access, As the membership number i need to use the first letter of the surname, then have an auto number. e.g Smith, if the last member was S47 then Smith would need to be S48, This will be used on a form for a video hire shop, so, the customer details will be entered, is it possible for this auto number to work just by putting the name in the surname field? I only know basic Access so please help. Thanks a lot Nick
View Replies !
View Related
Order A SQL Query ASC , DESC Or By Letter
Hi guys got 3 SQL queries showing the same data of three types. Special Offer Terms Contracts I would like to show all three in the same table and then have three seperate links that would bring the relevent one to the top but keep the other two in the table. I can use asc and desc in the order by of the SQL statement to get terms or contracts to be at the top but how would I get special offer at the top ???? any ideas ... Cheers
View Replies !
View Related
|
TRACKER
